Data manipulation in Access, the best way?

[carl_mcdade]

I have an Acces database that needs some heavy scrubbing. The Access gui is terrible for this. So my question is what is the best way to do do thing like move substrings and re write spelling errors on thousands of rows? It's one large table.


Macros in VB (I am weak on this but if it is faster than ASP)
ASP (connecting to the db seems to be the fastest way to me)
Excel
Export to text file, fix with RegExs and re import (leaning towards this option)


Have you got something better? I am interested :)

[weronpc]

Visual Basic, Java, PHP or ASP. All of them is fine.

If speed is what you are have problem with, I suggest you change Access Database to something like MySQL or MS SQL.

[Antoniohawk]

This might help you out some: [http://www.mrexcel.com/articles.shtml].