adding a header

[Guest]

i have to import an excel file into an access data base. the excel file does
not have a header. how can i add a header with column headings of 'col mod
rate 1 rate 2 ' before importing to the access file.

thanks for your help

 

[Douglas J. Steele]

You'd have to use Automation to open an instance of Excel, load the
workbook, insert a row into the worksheet and populate the cells as
appropriate.

Another option would be to import it as-is, then rename the fields in the
resulting Access table.

 

[Guest]

how would i rename the fields in vb code?
thanks

You'd have to use Automation to open an instance of Excel, load the
workbook, insert a row into the worksheet and populate the cells as
appropriate.

Another option would be to import it as-is, then rename the fields in the
resulting Access table.

 

[Douglas J. Steele]

CurrentDb.TableDefs("NameOfTable").Fields("OldName").Name = "NewName"

 

[Guest]

thanks much

CurrentDb.TableDefs("NameOfTable").Fields("OldName").Name = "NewName"