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

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
 
T

Tom van Stiphout

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

-Tom.
Microsoft Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Performing a Query from SQL Server Against Access? 1
Reaching Access 2003 datas via SQL Server 2005 64 bits 2
Access 2003 or 2007 Compatible with SQL Server 2008 6
Access 2000 ADP and SQL Server 2005 2
Inserting data to MS SQL 2005 using Access 2003 with subform 1
Access 2003 & SQL Server 2005 4
Call a MS Access 2003 Report from SQL Server 2000 3
Access 2003 / SQL Server 2005 Data Access (not design) 1

Top