P
phillip9
Hello,
I have a large national database (sybase) that I need to pull data from
through ODBC.
The problem is that our slow network does not allow me to use Linked Table's
because data is corrupted or duplicated when using the Linked Table's. So,
up to now I have imported the local data (1110 records) manually trimmed from
the 38000 records in the national database table's.
I would like to automate this using VBA. Can anyone give me the objects
that would allow me to connect to the ODBC datasource and pull out only the
records I need?
To take it one step further, I would like to even be able to pull only about
15 fields from each record, which normally contains about 38 fields.
Thank you,
I have a large national database (sybase) that I need to pull data from
through ODBC.
The problem is that our slow network does not allow me to use Linked Table's
because data is corrupted or duplicated when using the Linked Table's. So,
up to now I have imported the local data (1110 records) manually trimmed from
the 38000 records in the national database table's.
I would like to automate this using VBA. Can anyone give me the objects
that would allow me to connect to the ODBC datasource and pull out only the
records I need?
To take it one step further, I would like to even be able to pull only about
15 fields from each record, which normally contains about 38 fields.
Thank you,