Exporting data from Access to SQL Server

  • Thread starter Thread starter Endeavour
  • Start date Start date
When I have SQL-Server designs I'm working with in Access, the SQL-Server
tables are linked to my Access .mdb file.

I don't need to use VBA to "export or modify data", since the table's
already connected.

What design are you using?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Is there a way in an Access VBA module to export or modify data in SQL Server
Click to expand...

Sure. This is a big topic, but in general you can declare a DAO or
ADO recordset and read, update, insert and delete records in SQL
Server tables from VBA.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com
 
If your intent is to move data currently in a Jet database to an SQL
database, the easiest way is to link to both tables and use an append query
to copy data from the mdb to SQL.

If you are talking about day to day data operations, then Jeff provided the
correct answer.
 
Back
Top