Exporting SQL to Access via VB.Net Form

dazzer · October 21st, 2003, 05:39 AM

I am writing an application that needs to pull data from a SQL server db into an MS Access db from an onclick button on a VB.Net windows form.

I have read that I could use command files but then I have read that .cmd are not recognisable on W2K systems. The user may be using 98 so cannot do.

Thanks
Darren

sal · October 21st, 2003, 10:15 AM

Are you doing something like, allowing your customers to get data from your SQL Server into their MS Access Database? or is this an internal Application to your company only?

Sal

rdmayhew · August 10th, 2004, 04:16 PM

I'm interested to find out if you get it to work. I've been trying to either copy the SQL Server database into Access without dropping indexes on some of the tables. I can run queries through xcel without a problem.