Importing data from ms excel to ms access using vba

[wedd]

Is there a procedure where I can import data from ms excel, import graphs and import all the required spreedheets of different related tabs of data into ms access 2007 (using vba) to generate professional looking reports in ms access?


Thanks for your ideas:friends:

[OBP]

You can Import Woork sheets in to tables or Imbed Graphs in Reports. I have never heard of importing Excel sheets in to rpeorts. Although you can copy & paste an "Image" of an Excel sheet.

[Frenchy646]

There is an import command you can do, although I cannot remember exactly what it is.
However, I think this only does data.
I'm guessing that using the access import function to import data from a spreadsheet to your database isn't going to satisfy your requirement ?

If you give a few more details of what you want to do, I may be able to help, as I have recently written a VBA module to import data from my spreadsheet to the database tables.