Number format to Text

  • Thread starter Thread starter Sandy Burgess
  • Start date Start date
S

Sandy Burgess

I have had this problem numerous times. I have an excel file with a column
in a number format. I need to change the number format to text format for an
Access database. I have tried changing the excel format for the entire
column to text but the data still links to Access as a number format. How
can I change the excel file so Access will see the data as text?
 
HAve you treid Data>text to columns follow the instructions to save numbers
as text
 
Tried it - it didn't work. Data still linked to Access in a number format.
Thanks for replying.
 
Back
Top