Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
uplate
Starting Member
10 Posts |
 Posted - 2004-05-07 : 01:20:16
|
| Hello, I am new to this forum, and sql server, and hope someone can point me in the right direction. I created a vb project that the client runs. It logs into my sql server and connects to a database using ado and select a table from a sql server and fills a grid with 50 records. I now need to dump those 50 records into an access database that resides on the users local pc. Any Ideas? Thanks for your help. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-05-07 : 02:31:43
|
| Do you need to use VB for this? DTS or (if there is access from the server) an insert query could do it more easily.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
uplate
Starting Member
10 Posts |
Posted - 2004-05-07 : 12:30:29
|
| Thanks for your response.I have yet to mess with DTS. But the reason I use VB is that I have a system that uses DAO and Access and its been running for years. This system has over 100 crystal report reports that run off of the client local temp access files. I would like to keep the reports so if I use sql server data and when the client needs to print they can click a button and I can have it print from thier temp access files. Hope this sounds reasonable. Im looking for some code if possible.Thanks again! |
|
|
|
|
|
|
inserting into table