Erland and Greg,

Perl is not my thing. Beside, in this project there are actually two
tables that need to be links. The thing is that since many records
can only be linked using partial criterial (ex: "123" to match "abc123
xyz"), I still need to do this in a database.

Russ,

If I do this through ODBC by using Access as the front end (query
only) and SQL Server as the end back, how much slow down would this be
compares to run the query on SQL Server without using the ODBC linked
to Access?

Thank you all.

- Grasshopper -

"SQL Learner" <excelmodeling (AT) gmail (DOT) com> wrote

Not much if Access is run on the server with the data. If you are dragging 8
million rows across a network you are in for a long, long, long night.

Hi Russ,

That was what I meant - dragging 8 million rows across a network.
Thank you for your answer. In such case, I will run Access on the
server.

- Grasshopper -

"SQL Learner" <excelmodeling (AT) gmail (DOT) com> wrote

Well perl's not my thing either. ;-)

That's why I keep several perl buddies handy for stuff like this.

Quite honestly, someone know knows perl REGEXP inside and out can probably
knock off the pattern matching script in 30 minutes or so.

But yeah, if you're the only guy on the job, that's probably a non-starter.


Yeah, definitely run it on the server. Network lag alone would kill you.


--
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com