Sql 2000 into Access db 2000 using vb.net

[Javilen]

Hello,

I am trying to right an application that will dump the information from an sql server 2000 into Access 2000 via VB.net

The gist is, we have 1 table in sql 2000, it has 5 columns and 15 rows of data, one of the columns is a date that holds the info of when the record was added.

I want to select all rows that have a date between X and X and then dump them, in there entirety into an Access DB that I can then give to the client for them to build their own reporting off of.

I need to use VB.net 2005 to do this as the application will be placed into a schedule to run once every week or so.

Any ideas on how to do a direct dump with out reading every field of every line into a string to compile an insert statement to run into access.

The other problem is that one of the sql fields is a memo field and is multi line.


Please let me know what you think.

[Javilen]

I solved it on my own, I removed the vb.net programming and used the DTS built into sql to export the table I wanted based on the fields I wanted to the access DB. The DTS has a scheduling option that allowed me to schedule the process to run 1 a week when I wanted.

Thanks

[Plater]

I was going to suggest using DTS, but I wasn't sure how well DTS worked with automatic schedualing