Go Sales and Retailer install on Access DB?

[pimogo]

hello all! given the constraints of our environment, i've been asked to research how to best export  the go sales and retailer sample db into an Access DB. All the preliminary reseach i've made suggests the use of SQL server, etc.

Any ideas?

Thanks

[AussiePete2011]

Hi there,

SQL Server 200x can export to Access via ODBC without much trouble.

Use the BCP utility
http://msdn.microsoft.com/en-us/library/ms187042.aspx

This article is for DTS but the other way around Access to SQL Server
http://support.microsoft.com/kb/285829

Its not overly difficult to do but it also depends on the version of SQL Server.

hope this helps
Cheers
Peter B