How to import Excel formatted report into an MS access table

[maverick66]

Any easier way to import excel formatted report into an access table / database. - Thanks

 

[mdmilner]

Re: How to import Excel formatted report into an MS access t

An easier method than what?

My recommendation with a report, is to define the report as a named range, and then import the range. If you've followed good setup for the report, it should pick up everything include your column names (field names) when you use the import wizard.

Mike