I am in need of some assistance.
• I currently use MS Access thru an ODBC driver (Cache) to get to customers database to retrieve data
• I need to run a report for several years worth of data that will bust the 2GB MS Access limit
• I’d like to go from SQL Server --> ODBC -->Cache database and retrieve the data into SQL server as a local table so I can manipulate it and report against it
• I have no direct access to the cache database other than thru ther ODBC connection
SQL databse - name = Lee
Cache driver - uda_m_prd_lee
Cache table - is called charges
How can I run an import query into the SQL database to retrieve records from charges... / How do I setup the Linked server?
e.g. INSERT INTO Lee!charges
SELECT * FROM uda_m_prd_lee!charges