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 _______________________________________________ interchange-users mailing list suppressed http://www.icdevgroup.org/mailman/listinfo/interchange-users
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.