How to copy data from Access to SQL Server (using VBA)?

[Ai_Jun_Zhang]

Hi!

I have data in ACCESS DB and I would like to write some VBA code to copy data from a table in the ACCESS to a table in SQL Server 2000. Can anyone help me with this?

Thank you very much for your help.
Aijun.

[Leith Ross]

Hello Ai_Jun_Zhang,

Not sure why you posted your question which has to do with Access in an Excel programming forum. Here is list of groups you can post to about Access programming.

List of Access Newsgroups:

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[Ai_Jun_Zhang]

Hi!

I have written an application in EXCEL using VBA and user process data in EXCEL and saved them in Access DB. In the end, when user is done with data processing, the data in Access DB needs to be loaded in the SQL Server. I would like user to click a button in the application and the data will be loaded from access to sql server DB.

That is reason for me to post this question here since my application is written in EXCEL in VBA and user interface it with the FORM. As part of the user interface, I would like a button in the form called "Send Data" to copy the data from Access to SQL server.

Thanks,
Aijun.