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.
 

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

Convert Access DB to SQL 1
SQL Server 2
SQL PassThrough query - CSV Error 5
Example Of VBA SQL Statement 0
Access DB to SQL Server 19
Coverting linked tables into local tables 2
Exporting Data From Excel to SQL 1
Access-SQL Server object dependencies 3

Back
Top