I have a Employer Number in the table stored at a number. I'm importing it
into an Excel application which has it stored as a text field. Since Excel
has it as text field and it imports as a number all my Lookups don't work.
Accordingly, I would like to "fix" the format of the Access data right away
in the query I use to import the Employer Number.
I know how to change it in Excel, I would rather change it upon the initial
import since I will be handing this off to a less experienced user and I
don't want to bothert them with changing formats.
Accordingly, I would like to change the number to text upon import of the
queried information into Excel.
Is there a problem with changing the format of the cell in the entire table?
Or do you need it stored as a number in your database, then as text in a
query? If the prior is true, just go to design view in the particular table
and change the Data Type to Text.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
