import excel file in access

[jimache]

Hi everyone,
I am new to access and i appreciate any help i can get.
I need to import a excel file into a access database; some of the fields in the excel file are formated as number and without changing any formats in excel file i need to import all data as text fields in access.
Thank you for your help.

 

[jsteph]

I have found Access' Excel import functionality very limited. You can't change the field types, for example.

What I would do--if you have Excel on your machine or if the producer of these excel files could to this--is do a Save As to a .txt or .csv file. Now you can import the data as text, where you have much more control over setting up an Import Spec and chaning field types.
--Jim