Importing excel file to access with header row

[tinabunnybunny]

hi

i have some excel files which has the same format, with some header rows and they dont belong to one category. i wish to swich them into columns when i importing from excel to access. i dont know if i could do that.. and i tried with copy paste and append query. dont seems working that way.

thanks

[zmbd]

Hello Tina,

You'll need to provide a little more detail.
Office version, how your data is stored (format etc...)
If you want to type a table in, click on the [CODE/] button first and enter your formatted text between the <code></code> tags... use spaces not tabs to set columns.

There are many ways to import data in Access, all have there pros and cons.
The easiest method is usually to use the external data tab, link into the worksheet and either use that information as is or run an properly constructed append query to copy the data to the appropiate table(s).
From there you get into VBA/Macros (in ACC VBA is not the same as Macros as is the case in Excel).
Which method to use in VBA is very much dependent on how your data is arranged within the worksheets.