SQL to Access

[Danielle Romain]

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]

---