Need a macro to Import a Database

[joopdog]

I need a macro in Access to Import an ODBC Database. I want to write a macro or module to import data into a table using code. I know there's a simple macro code to import a file or database. I just don't know where to start.

I can manually import the data into a table.

I do this by the following:

1. Right-clicking in the table area
2. Left click on [B]Import[/B]
3. I look for ODBC databases and choose the DSN name [B]prodlgo[/B]
4. It’ll ask for username and password
5. Next it’ll bring up [B]Import Object[/B]. I then select the database to import.
6. The whole database is imported in seconds. DONE!

I need to be able to do the above steps in a macro or programming code. I did this in excel using Record A Macro, however, some of the databases are too big to import with over 200,000 records. Excel can only hold 65,536.

Here’s my Connection String for Access (It Works):

ODBC;DSN=prodlgo;ServerName=192.168.1.2.1583;
ServerDSN=prodlgo;UID=Sharon;PWD=qaz890;
ArrayFetchOn=1;ArrayBufferSize=8;DBQ=.;;
TABLE=CUSTOMER;"

Any help would be appreciated

 

[joopdog]

I got it!

Here's the assembly:



Hope this helps anyone else.

 

[joopdog]

I got it!

Here's the assembly:



Hope this helps anyone else.

 

[joopdog]

I got it!

Here's the assembly:



Hope this helps anyone else.