adding a header

J

jnewl

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
 
D

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.
 
J

jnewl

how would i rename the fields in vb code?
thanks

Douglas J. Steele said:
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.
Click to expand...
 
Top