invalid field names when importing from excell

[675i76]

I need to import a spreadsheet but the spread sheet has blank collums and
the first row contains abbreviations (e.g. DEPT. - with period). the
transferspreadsheet gives me field names "noname1", "noname2" etc and DEPT#.
How can I omit the blank field names and change the DEPT# to DEPT ??

thanks !

[pietlinden]

675i76 wrote:

I need to import a spreadsheet but the spread sheet has blank collums and
the first row contains abbreviations (e.g. DEPT. - with period). the
transferspreadsheet gives me field names "noname1", "noname2" etc and DEPT#.
How can I omit the blank field names and change the DEPT# to DEPT ??

thanks !

Blank columns.... create an import spec and have it skip the blank
columns.
Map the columns to the proper fields in your spec and you're done.

something like this. Just alias the illegal names with legal ones.

SELECT xlsHrsWorked.[Dept#] AS Dept, xlsHrsWorked.[Hrs# Worked] AS
Hrs_Worked, xlsHrsWorked.[Emp# Name] AS Emp_Name INTO tblHoursWorked
FROM xlsHrsWorked;

[RICHARD BROMBERG]

If you are only do this once or twice then the easiest way is to open the
spreadsheet in Excel and save it under a new temporary name.

Then open the new spreadsheet and edit it making any changes like deleting
blank columns, change the column headers to remove any illegal characters,
spaces, peculiar punctuation symbols (like #, $, *, etc.etc.)

Finally import this spread sheet.
<pi********@hotmail.comwrote in message
news:11*********************@j8g2000cwa.googlegrou ps.com...

>
675i76 wrote:

I need to import a spreadsheet but the spread sheet has blank collums

and

the first row contains abbreviations (e.g. DEPT. - with period). the
transferspreadsheet gives me field names "noname1", "noname2" etc and

DEPT#.

How can I omit the blank field names and change the DEPT# to DEPT ??

thanks !

Blank columns.... create an import spec and have it skip the blank
columns.
Map the columns to the proper fields in your spec and you're done.

something like this. Just alias the illegal names with legal ones.

SELECT xlsHrsWorked.[Dept#] AS Dept, xlsHrsWorked.[Hrs# Worked] AS
Hrs_Worked, xlsHrsWorked.[Emp# Name] AS Emp_Name INTO tblHoursWorked
FROM xlsHrsWorked;