As previously stated, DTS should work for you. I actually just did this
yesterday so if you need assistance, feel free to contact me off list and I
would be glad to help. I did not run into any issues and we are no longer
taxing our CF server with fetching the records from the SQL box and looping
over to pump them into 3 different access DBs.
Mike
-----Original Message-----
From: Danielle Romain [mailto:[EMAIL PROTECTED]
Sent: Monday, December 01, 2003 9:42 PM
To: CF-Talk
Subject: SQL to Access
The project that I am working on requires dumping data from SQL Server into
a table in Microsoft Access. I am currently using a stored proc to fetch
the needed information from SQL then looping through each row in the
returned query in order to populate the Access data table. I'm concerned
that this solution will be too slow for use in production.
Any ideas???
You're help would be appreciated.
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
