Importing Excel File

[Guest]

I was 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 can I import all the data as text fields into
Access?

Thanks

 

[John Nurick]

Hi Steve,

See my answer to an almost identical question in this group on 4
October, from Linda, under the subject "How to import numbers from
Excel".

 

[Jamie Collins]

I was 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 can I import all the data as text fields into
Access?

SELECT
LEFT(MyExcelNumericCol, 255) AS MyJetTextCol
INTO
MyNewTable
FROM
[Excel 8.0;HDR=Yes;Database=C:\Tempo\db.xls;].[Sheet11$]
;

You also need to ensure Jet sees the Excel columns as numeric. See:

http://www.dicks-blog.com/excel/2004/06/external_data_m.html

Jamie.

--