Import Data via Command Button

I

Ivan Grozney

I have a user that wants to import data via an ODBC
connection but have it on a cmd button. Can this be done?

tia

Ivan
 
I

Ivan Grozney

To quote Homer Simpson D'OH!!!

I got it working. Here is the code I used (with linking
to the SQL Server and then replacing my current local
table so that the captions wouldn't change) in case anyone
cares...

Dim stQDocName As String
Dim stQ2DocName As String

DoCmd.SetWarnings False

' delete all the data in the tbl_conditions table
stQDocName = "qry_DEL_Conditions"
DoCmd.OpenQuery stQDocName, acNormal, acEdit

DoCmd.TransferDatabase acImport, "ODBC Database", _
"ODBC;DSN=ConditionalSystems;LANGUAGE=us_english;" _
& "DATABASE=ConditionalDB", acTable, "cond", "tbl_CT"

stQ2DocName = "qry_APP_Conditions"
DoCmd.OpenQuery stQ2DocName, acNormal, acEdit

DoCmd.DeleteObject table, "tbl_CT"
DoCmd.SetWarnings True
 

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

sqlite-odbc write conflict 2
Table Security in Access 2013 1
How to map SharePoint drives permanently 0
Crating User Form to Add Names 1
Getting Radio Buttons to work, that are inserted via AutoText 0
How to sync OL365 contacts and calendar to iPhone without iTunes? 1
How can I get a Shareable URL via VBA code to a OneDrive image? 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0

Top