Removing spaces from column names

[Davidc316]

Hi,
I am transferring a table from Access into MySQL. The table has lots of columns (over 200) and some of the column names have a spaces in them.

Is there any way I can loop through all of the column name and remove the spaces so that it's a little more mySQL friendly? (so, if for example there is a column called "Top Speed", I'm wanting to change it to "TopSpeed".

Many Thanks.

[TheDefender]

Yeah, go through it in Access and just remove the spaces one at a time... Even with 200 columns, it still won't take that long.

[Percadan]

PHP trim()

or

VBScript replace()

[bradgrafelman]

Or 'Find & Replace' in MS Access ...

[Percadan]

sure.