Best Method for Reading Query from Microsoft Access 2003 database

[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

[Mary Chipman [MSFT]]

One method would be to create a linked table from Access to the
destination table in SQL Server. You can then run append queries from
the Access source to the SQLS linked table as needed.

--Mary

Post by 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