DB Question

[monte_russell@uswest.net]

Anyone know how to:

I am building a store that will house over 7000 different items. I have a solution for my product graphics, uploading them one at a time is not a option I want to entertain. (No FTP access on the server the store is on.)

What I have is a data base with my product, I export the data to a tab delented text file then upload the file to my store. I need to add the graphic statement to all my products that have a graphic, I know how to merge cells in Excell, the thing is I need to merge the graphic name into the statement, then add the statement to the description field.

Am I asking for something that can't be done?

If it can be done would someone who knows point me in the right direction, this one is giving me a very large headache!!

[stampedeproject]

I think you are looking for the "&" statement like this:

=A1&" Hello "&A2

The example being:

A1 = 1
A2 = 2

produces output of

1 Hello 2

[monte_russell@uswest.net]

Yup, I was really bummed out last night when I posted this.

I have a bunch of graphics I need to host off site where my store is. This morning I used the help file (amazing what you can find there!) and figured out a way to do it wth this command, I have to do four merges to get the whole statement to work.

Got busy and for got to answer my own post

Thanks for the reply.

[monte_russell@uswest.net]

[Sigh]
This begining to be annoying, I export the spread sheet to a tab delented txt file, any where there is a " the eported text had a double " like this:

"<img border=""0"" src=""http://

It has to be a simple fix but I haven't found it yet, anyone know where I messed up?

Thanks.

[loren_d_c]

This is an Excel issue, see the following ShopSite Knowledgebase for a couple of suggested workarounds:

http://support.shopsite.com/kbase/view_answer.php?questionID=S02720

-Loren

[monte_russell@uswest.net]

Thanks, I think I'll use the find and replace method in note pad.

Nothing is ever easy, eh?