ok, my goal here is to import data from various ACCESS
databases after washing the data in T-SQL. My first tack
is connecting to the various MSAccess databases. any help
would be greatly appreciated.

Rob W

Thank you so much. That worked like a charm.

*** Sent via Developersdex http://www.developersdex.com ***

You can connect to external data sources using linked
servers or using openrowset. Both are documented in books
online with examples on connecting to Access databases.
If you plan on importing this data into SQL Server after
scrubbing it with T-SQL, another approach that would likely
perform better is to load the data into staging or scrub
tables (tables you use to just load the data raw before
inserting the data into the destination tables in SQL
Server) and then perform the data scrubs on the staging
tables. So you'd just do the data cleansing locally in SQL
Server rather than through the external data source
connections.

-Sue

On Mon, 3 Nov 2003 10:34:51 -0800, "Rob W"
[quoted text, click to view]