importing data from excel into a new Access table

[rvd48]

i've got 12 worksheets in a excel file. i want to import them all into one new table into Access, i go to File> Get external Data>Import.

though it only allows me to select one worksheet, i would like to select them all, how do i do this??

 

[Mile-O]

Obviously you can't do this by default because different sheets might have different structures.

If they are similar, use the TransferSpreadsheet method (by code or macro) to set the macro up. You'll still need to change the sheet name to get all 12 sheets in.

 

[neileg]

You need to do one sheet at a time, but you can add them all to the same table, providing the structure is the same.

 

[rvd48]

i've imported the sheets one by one.
now when i go to my form, for some reason it brings up a parameter box asking to enter GRAHPICS CARD.CODE value, i've checked my tables and query nothing looks out of the ordinary,

can u help?

 

[Mile-O]

for some reason it brings up a parameter box asking to enter GRAHPICS CARD.CODE, i've checked my tables and query nothing looks out of the ordinary,

Are you sure you've checked the spelling of GRAPHICS?

 

[neileg]

 

[rvd48]

thanks mile , i got it sorted now

btw, is that a picture of gail porter?

 

[Mile-O]

is that a picture of gail porter?

No; it's Audrey Tatou.

 

[rvd48]

Obviously you can't do this by default because different sheets might have different structures.

If they are similar, use the TransferSpreadsheet method (by code or macro) to set the macro up. You'll still need to change the sheet name to get all 12 sheets in.

im interested in the 'TransferSpreadsheet' by marco approach, can you provide any info on this or some links to tutorials?