Append externally sourced recordset to local access database

R

Rob Wills

Hi,

I wish to connect to a Sybase database using a recordset - to remove the
need of having to link the table through ODBC using DSN. (to prevent the
users from fiddling with the source data)

I can create the recordset programatically - but then I want to save to a
local table without writing the code to loop through each field in each
record to append the data within Access.

I've recently read about saving the recordset to disk - might the following
be a better soloution?
1, Open the ADO recordset
2, Save the ADO Recordset to disk
3, Close the recordset
4, Import into Access using a schema

Any other ideas are welcome
(Preferably one that means I can just run a single SQL string)

Thanks
Rob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

>> ADO Updateable recordset 3
Creating a table from ADO recordset 0
Changing pivot table ADO recordset 0
A theoretical question: how best to manage perpetual recordset needs? 24
How to do an append query to a table from a recordset 2
Refering to Opened ADO Recordset as Datasource 0
Append a recordset 1
Append Passthrough Query Results to Local Table 2

Top