import data from Excel without changing format

  • Thread starter Thread starter john
  • Start date Start date
J

john

Suppose you are asked to import an Excel file into a
Microsoft Access database. Some of the fields in the
Excel file are formatted as numbers. Without changing any
formats in the Excel file, how would you import all the
data as text fields into Access?

Thanks a lot!
 
Import the spreadsheet into a temporary table. Then use an append query to
copy the records, using the desired formats, into the permanent table.
 
Ther are a number of ways. First of all are you importing
to an existing table or new? An existing table will keep
the Access field formats.

If importing to a new table here are two options.
Insert a dummy first line of data in the first data row of
excel. Make the fields info alphanumeric. You can delete
this row later with a query or manually.
The second way would be to insert a single quote infront of
all your numeric fields in Excel. The data will be
imported as text.

Good luck

Jim
 
Back
Top