Nov 10 2006, 09:15 AM
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?
Nov 10 2006, 09:21 AM
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.
Nov 10 2006, 09:39 AM
Thanks Noahp, this will work
Nov 10 2006, 03:53 PM
You are welcome!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here