Query to change the type of a field.

[mystuff]

Hi,

I import an excel spreadsheet to a table everyday that has a field formatted as "text", but contains a "number" value. The number comes in with a space in front of it. Every day I manually remove the space by going into the design view, changing the format of the field from "text" to "number" and clicking "save". (This also gets rid of records that have a blank or null in the field which is what I want too.) I would like to accomplish this in a query or using vbasic. Does anyone know the best way to do this? Thanks.

 

[SiJP]

Please do not ddouble post across forums

CLng(myfield)

------------------------
Hit any User to continue

 

[mystuff]

OK, but the question was a Visual Basic question and a Query question, so I wasn't sure where to post it. Sorry about that.

 

[SiJP]

The same function can be used in both VB(A) and your query..

------------------------
Hit any User to continue