Importing From Excel to Access
Hey Guys,
I want to design a form in VB6 through which users can browse for an Excel file and the data from excel sheet can be imported to MS Access Database during runtime. The format of data ( columns and rows ) in the excel sheet will be always same. Any idea??? Please help .. . . :ehh:
Re: Importing From Excel to Access
There are examples in the article How do I transfer data between Excel and Access? from our Office Development FAQs (at the top of the Office Development forum, and linked from the Access section of the FAQs/Tutorials at the top of this forum)