Posted by Russ Rose on 03/02/07 03:24

"SQL Learner" <excelmodeling@gmail.com> wrote in message
news:1172791357.025040.97000@s48g2000cws.googlegroups.com...
> Hi,
>
> I have a table with 8 millions records. Some of the fields needed to
> be parse and modified. Example, "ABC DEF" will be parsed into two
> fields "ABC" and "DEF". And If there is "123" in the field, if will
> be replaced by "456". For example, "XYZ 123 AAA" will be "XYZ 456
> AAA". Also, update query and append query will be used in the
> project.
>
> Give the above information, what will be a faster database to do this
> - MS-Access 2003 or SQL Server 2000?
>
On equal hardware SQL Server 2000 will run the query faster. Depending on
your skills it may take longer to write the queries on SQL Server 2000 than
it takes to write and run in Access...

[Back to original message]