[ic] Cannot upload products.txt via excel, or through the admin, Excel major issues please help

DB interchange-users@icdevgroup.org
Sat Nov 2 20:29:35 2002


> Ok here the issue. I need to upload a lot of products to my database.
> Inputing my items manually via the admin takes to much time. I need to input
> the data in a excel spreadsheet and upload it.

I think I asked this same question awhile back and received a helpful 
reply. There may be better ways, but here's what works for me.

Edit the Excel spreadsheet and save in .xls format. Open that same 
spreadsheet in Access, then export as tab delimited choosing "include 
field names in first row" and "none" for text qualifier. Doing that, I 
can use the GUI's table import function.

I was never able to get text files exported directly from Excel to work 
properly.

DB