Problems with Import Formats

R

Ritesh Sara

Hi guys,

I´m facing a problem when importing Excel data into Access. I have 1 column
with the format Text, however when importing into Access this is imported as
number and all the values are getting lost.

I already tried to create an Access table with the proper format settings
but I get an error when trying to import the Excel sheet into this table.

Could somebody assist please?

Thanks,
Ritesh
 
E

Eric Wattez

Try importing the data into a dummy table (create table with import function)
and then use a query to insert the data (with the correct format) into the
actual table.

If this doesn't work then you could open and import the excel sheet with
code... but this will prob be the long and difficult way to do things...

Regards,

Eric Wattez
 
Top