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 |
|
Pago
Starting Member
1 Post |
 Posted - 2004-09-05 : 15:29:21
|
| Hi all!I'm working In a VBA application and a Ms Access mdb and need to do this:I need to make a select records from a table and put those records on a new table on new database, so far so good. But between these steps I need to delete the first table from the first .mdb after a Select and then put this selection on a new table on the second database .mbd. I think i would probaly need to cache those records but how can i do that.Sorry if i didn't explain myself vere well but i'm newbie on this things.Thanks!Paulo Gonçalves |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-09-05 : 19:15:45
|
| There's many different ways you can do it - depending on your preference:1. Do a SELECT INTO a temp table. 2. Drop the records out into an XML file. All you need to do is create a recordset and then save it as XML format to disc3. Open a disconnected recordset4. Drop it to a CSV |
 |
|
|
|
|
|
Working with cache