importing columns from excel

  • Thread starter Thread starter DC Gringo
  • Start date Start date
D

DC Gringo

Using the importing wizard, I'm trying to bring in an Excel spreadsheet.
I'm not finding any way to map the import column for column and the wizard
ends in failure with no options...please help!

_____
DCG
 
Among the options:

1) ensure that column headings in the worksheet range match the field
names in the table you're importing to.

2) temporarily link or import the worksheet (using the wizard) and then
use an append query to map fields and do any necessary type conversions.

3) forget about the wizard and write the SQL statement for an append
query to move the data from the worksheet into your table. The syntax is
like this:

With column headings, import from specified range:
INSERT INTO MyTable
SELECT Column1 As Field1, Column2 As Field3, Column3 As Field2
FROM [Excel 8.0;HDR=Yes;database=C:\MyWorkbook.xls;].[Sheet1$A1:C999]
;

Without column headings, import from named range
INSERT INTO MyExistingTable
SELECT F1 As Field1, F2 As Field3, F3 As Field2
FROM [Excel 8.0;HDR=No;database=C:\MyWorkbook.xls;].[MyRange]
;
 
Back
Top