importing xls in access

[databasedonr]

Sportsguy, you're the best

Thanks again for posting the link to the other article. This worked a treat; I had it up and running in about 10 minutes. Sorry for the delay in posting back -- I was tied up sorting the Excel spreadsheet and making the Sheet match the fields in Access.

If anyone is interested, I can post my code, but it's essentially the same as that in the link. This works amazingly well, and has dozens of applications in my environment, where we collect data using Excel and then use/manipulate/report the data using Access.

Thanks again -- another time this Forum and it's contributors have made me look good!

 

[mbrost]

There is a very simple solution for importing sheets with a click on a button...

Go to macro's en build an import macro. In the design view of the macro you can select an option to import whatever you want. Specify the desired format and other stuff and your import macro is ready...

Then just go to form design and create a button. After that you just put in the buttons properties the name of the macro as desired action...

No code knowledge necessary to solve this problem you know...

This is definitely the solution I'd recommend -- this took me 5 mins, she works perfectly