Import excel into database

[CD Tom]

I have a very large excel file runs from A to GV. Is there a way to bring this into my database. I would like to split this into maybe two or three tables. Now the excel file comes from an online registration system and I have no control over the size of the file. I would like to do this through Access VBA so my end user doesn't have to do anything but click on a button that will run my program to input this Excel file.
Thanks for any help.

[NeoPa]

Still can't ask a question to save you life I see Tom :-(

Yes linking to, or importing from, Excel is possible. Sometimes it needs VBA but not always.

The rest is just a statement of requirement and you should know by now we're not here simply to do your work for you. Feel free to update your question in such a way as to be valid and we'll be happy to see what we can do to help.

[CJ_London]

A>GV is 204 columns so should not be a problem to link and run a number of append queries to populate your two or three tables. This can be automated.

So to answer your question, yes there is a way to bring this into your database. In fact a number of ways, but which way is best suited to your requirement depends on the detail which you have not provided.