Hello,

I’m looking for a way to automate the formatting of a field in a table

What I’m doing is importing a excel spread sheet into access, but one of the fields I want to be text is showing up at a number.

Is there anyway I can have access change this field from a number to a text field?

Thank you

Corey

The 'quick and dirty' way to do this is to import the data into a temp table, and then use an append query to format the data to the datatypes you need and insert the records into the 'real' table. The CStr() function will convert data to a string/text type. Access/VBA Help should have more on the specifics.

Thanks Noahp, this will work

You are welcome!