adding a header

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
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...
 
Back
Top