
Signature
-Matt
"The only thing worse than an employee that just quits and leaves, is an
employee that quits and doesn''t leave."
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.
> Without changing the format in the table? What exactly are you trying to
> accomplish with this? I'm not sure I follow...
>
> > Is there a way to format a number as text in my query?
Matt - 29 Apr 2008 15:25 GMT
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.

Signature
-Matt
"The only thing worse than an employee that just quits and leaves, is an
employee that quits and doesn''t leave."
> 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
[quoted text clipped - 13 lines]
> >
> > > Is there a way to format a number as text in my query?