Opening Access Tables Directly in Excel

Posted on Thursday 5 January 2006

Maybe I’ve missed the boat on this one but I never knew you could open an Access table directly inside excel, I’ve always exported them to .xls files in Access, or used Get Extrenal Data. In Excel, file open (pick all from the type drop down) and click on the Access DB, give you this:

Cliciking the table will import it into excel - i guess it errors out when you go over 65537!


No comments have been added to this post yet.

Leave a comment

(required)

(required)


.

Use [VBA] Your Code [/VBA], when posting code, cheers Ross x /


RSS feed for comments on this post | TrackBack URI