exporting into sql

D

dennis

Does anyone know if there is a way to export data from an
existing access database into sql statements?
 
K

Kevin3NF

The question does not make sense, unless you are wanting to generate an
Insert statement for each record. If this is the case, I don't think Access
has any utility for this, but some 3rd party tools might.

If the destination is SQL Server, you can move the data in a variety of
ways.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
 

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

VBA Export to PDF 0
Solved Disk Full error message when exporting PDF 0
Access 2016 docmd sendobject crash after March update 0
Exporting Data From Excel to SQL 2
Office365 Family + TXT or MX Domain 0
xml export 0
VBA - exporting serial letters to single documents 0
Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine) 0

Top