Performing a Query against Access 2003 from SQL Server 64 bit?

  • Thread starter Thread starter Joe_A
  • Start date Start date
J

Joe_A

Hi,

We have a legacy analysis application in Microsoft Access 2003 (X) that
reads a large subset of a second MS Access 2003 database (Y) into temporary
tables and performs certain operations on the temporary data set. To improve
performance, we have began to port the application (X) to C# on SQL Server
2005 64bit edition. Unfortunately, the MS Access 2003 database (Y) that
serves as the original source for the data has to remain in MS Access 2003
and is updated via a feed throughout the day. Our analysis application (X)
needs to continue importing its initial data set from Access everytime a user
initiates an analysis request.

What are the various methods we could consider to execute import of various
queries from MS Access 2003 to SQL Server 2005 64bit, given the large size of
data being imported on demand?

Thank you
 
Importing data in SQL Server should typically be done with SSIS = sql
server integration services.

-Tom.
Microsoft Access MVP
 
Back
Top