Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Export Access Table to SQL 2000

Status
Not open for further replies.

xtreemnet

Programmer
Joined
Aug 9, 2003
Messages
88
Location
NZ
Hi

I would like to export an Access table to SQL 2000 through Visual basic 6. I have used OpenSchema method to get the deails of the MDB file, so I can select any table to export.

Can somebody guide me please,

Thanks,
 
The easiest way of doing that is through SQL Server DTS.
And if you need to pass data from one to the other it will also be the fastest.

No code needed.


Regards

Frederico Fonseca
SysSoft Integrated Ltd
 
This small appliation will be used by my office fellow who is not a programmer, so I wanted this to be coded completeley. I am sure there must be a way to this. I searched on Google a lot but could not find a code.
 
If you use DTS you can schedule the job to run whenever.

Is this a one time export or a recurring thing?
 
If you search these forums you will also find ways of creating tables, either using plain SQL or using ADOX.

Those samples will help you do that also, but transferring the data from one table to the other will alwyas be slower (by far!!!) then using DTS.

Regards

Frederico Fonseca
SysSoft Integrated Ltd
 
This is not one time and the table will be different(structure and data) everytime.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top