import sheet from excel

[Guest]

Hello everybody:

I am a beginner Access user and I am trying to build a macro to import a
specific sheet form a spreadsheet. I am using the following sintax:

File name: P:\XXXXX\YYYYYYYYYYY\File,worksheet

However I cannot run the macro.

I really appreciate your help !!

Edgar

 

[Guest]

Hi,
have a look at the docmd.transferspreadsheet method.
Try to adapt VBA. Macros are very very limited and cannot handle error
handling.
HTH
Good luck

 

[nanne]

quite easy

create a sub-sheet in Excel with the required data.
make sure the first row as the same fieldnames of your table in Access
Open Access and use IMPORT and follow the instructions.

success

Nanne