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
 
Back
Top