Text columns exporting to currency columns

  • Thread starter Thread starter Marc
  • Start date Start date
M

Marc

I have never seen this before. I have verified and double checked the data
type in my Excel spreadsheet which is a text column and in Access it is also
a text column. Importing the data from Excel to Access is ok, it's when I
export to a fixed width text file is when it gets messed up. I can't figure
out why the data in this particular item is exporting as a currency data type
when it's clearly a text data type. Any ideas?
 
Marc

Are they numbers (i.e., digits)?

In your query (I'm assuming you are using a query to get the data to
export), are you explicitly coercing the field(s) to be text, using the
CStr() function?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
They could be both numbers or letters. I've tried entering the just letters
and when I export it from the query it gives me a message that it's a
datatype violation. I guess I don't understand because I have other columns
like that and they export fine.
 
Marc

If you leave it to Access to decide, it may not get it right.

What happens if you coerce the field using CStr()?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Found out my saved specification was corruppted. I had to delete and make a
new one. After that I didn't have any problems. Thanks for the help!
 
Back
Top