Acess question

[monte_russell@uswest.net]

O am using an Access data base, I have read here that a few posters say they use an access data base for thier products/orders/customers.

From what I have read the data has to be export to a text file before it is usable by Shop Site.

Am I mistaken?

Thanks for any enlightenment you can provide.

[Jim]

Yes, it must be exported to a tab delimited format in order to be uploaded into ShopSite. I don't know if Access can export as XML format but if it does that could also be used.

[stampedeproject]

This drove me nuts also.

I finally ended up writing the XML and Visual Basic code to import the Shopsite 8.1 Orders XML based file into MS Access 2003.

My import separates the orders file into one table with billing, shipping, and payment information, and another table with the product order data.

Basically you just download the XML order file to your hard drive, click one button and the script and transformation files handle the import then delete the downloaded files from the drive.

I have it working and importing orders for 2 stores, but you could use it for just one store.