Excel to Access Design View

[krishhi]

Hi there,

I have an excel file, which has many tabs. Which contains user data. See the attached sample file.

I want to export this data to access, but it takes too much time to copy each cell in to access.


Is there any way to export this data to Access Design view mode.

I know the way to export the excel file to access. But I need to export the data with their variables and description.

Please check my attached file so you can easily understand what i need.

Thanks in advance.

[HiTechCoach]

In Access I would use Excel Automation VBA code.

See: Import Data from Microsoft Excel (http://www.hitechcoach.com/index.php?view=weblink&catid=84%3Aaccess-vba-office-automation&id=300%3Aimport-data-from-microsoft-excel&option=com_weblinks&Itemid=23)