importing table using ODBC

  • Thread starter Thread starter Bre-x
  • Start date Start date
B

Bre-x

Hi,
I need to import a ODBC table using VBA

anyone call give me a idea how to do that?

Thank you all

Bre-x
 
DoCmd.SetWarnings False
DoCmd.TransferDatabase acImport, "ODBC",
"ODBC;DSN=UMCClientDB;ArrayFetchOn=1;ArrayBufferSize=8;DBQ=UMCClientDB;OpenM
ode=0;DecimalSymbol=.;ClientVersion=8.10.121.061;CodePageConvert=1252;AutoDo
ubleQuote=0;", acTable, "WOLABOR", "WOLABOR", False
DoCmd.SetWarnings True

Thnks
:P
 
You must log in or register to reply here.

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

Web Toolbar 2
Importing Text Problem 2
Importing Data 5
Alter Table 1
Autoincrement 4
ms access as a backend 1
change the value of a combo box 2
Importing Text 1

Back
Top