Open Excel 2007 spreadsheet in Access

[NEHU]

i m using ms office excel 2007 version how do i open it in database ms acess
earlier i used excel5.0 ,,now what?

[jeffstl]

This probably belongs in a Access forum or something.

Anyway you would need to go into Access and choose "Import" and import the data from excel into access.

You can either do that or set up a table exactly like your excel sheet, and then copy and paste the data over, though depending on how much data this solution isn't the best one, especially if there are problems with pasting.

[Killer42]

Yes, I'm going to move it from the VB forum to the Access forum. And change the title from "vb query" to something a bit more descriptive.