transfer spreadsheet macro

[hideaki25]

is there any way to specify a particular sheet in a workbook if you have more than 1 sheet when you do a transfer spreadsheet for importing in data from an Excel 97 spreadsheet into an Access DB (97) ?

 

[mailzero28]

Hi there,

If you use the TransferSpreadsheet option in a Macro, it allows you to define what sheet you want to specify.

bye

Martin.

 

[hideaki25]

Thanks for the info. I actually just saw that in the help file of access where you can go name what sheet you are looking for in the range section.

Thanks again for the reply !