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
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