Search results
-
J
Need a macro to Import a Database
I got it! Here's the assembly: Hope this helps anyone else. -
J
Need a macro to Import a Database
I got it! Here's the assembly: Hope this helps anyone else. -
J
Need a macro to Import a Database
I got it! Here's the assembly: Hope this helps anyone else. -
J
Need a code to Import a Database
I got it! I figured it out: Private Sub CmdReadDBF_Click() ' To Import the Database DoCmd.TransferDatabase acImport, _ "ODBC Database", _ "ODBC;DSN=prodlgo;ServerName=192.168.1.2.1583;ServerDSN=prodlgo;UID=Sharon;PWD=qaz890;ArrayFetchOn=1;ArrayBufferSize=8", _ acTable...- joopdog
- Post #4
- Forum: Modules & VBA
-
J
Need a code to Import a Database
I've tried the Code. It looks like it's going work. DoCmd.TransferDatabase , "ODBC Database", "ODBC;DSN=prodlgo;ServerName=192.168.1.2.1583;ServerDSN=prodlgo;UID=Sharon;PWD=qaz890;ArrayFetchOn=1;ArrayBufferSize=8;DBQ=.;;TABLE=CUSTOMER;", acTable, "test", "tblTest_dbf" However, I get a run-time...- joopdog
- Post #3
- Forum: Modules & VBA
-
J
Need a code to Import a Database
I need a code 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 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...- joopdog
- Thread
- Replies: 4
- Forum: Modules & VBA
-
J
Need a macro to Import a Database
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...