Please Help, difficult situation on importing table

[utxin]

Hi I got a really hairy situation.


I want to import a particular table from an ERP database called
Macrosoft (very little known relational database). The normal
procedure would be to

1) Right click on the database explorer
2) Import database
3) Select odbc database option
4) Chose machine source
5) Select the connection that I made before hand in "control
panel-->admin tool-->odbc databases"
6) it then gives me a list of tables that I want to import.

I thought of using Transferdatabase method but have so far failed (as I
am not even sure where to start). Could someone please help me. The
ERP is made with python if that helps.

 

[Jeff Boyce]

Have you considered doing an export from the ERP db into a "common" format
(e.g., Excel, csv, ...)? That's something you could readily import into
Access, without resorting to creating an ODBC source.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[utxin]

yes i have, but the problem being that i want to do this automatically
so that every time i update i would not have to go through the process
of export(from erp) then import(to excel) then export(to access). But
that gives the an idea.

Perhaps i could use excel's common command to refresh data from source
through its odbc connection.

Then import it into access.

 

[utxin]

Found the solution in one of the threads! Thanks guys I will post my
solution.

to find out the connection string for the ODBC database, simply link a
table to that ODBC and then in design view --> properties. You can
then view the connection string in one of the boxes there where you can
cut and paste into your Transferdatabase method.