Excel to Access Conversion

Category:
Office/VBA
Type:
Applications
Difficulty:
Intermediate
Author:
sreekumar

Version Compatibility: Visual Basic 6

More information:
  1. This will Convert an Excel Sheet to an MDB File
  2. Assumed the Excel Sheet name as Book1.Xls.
  3. Change the name if you want to refer to some other Sheets.
  4. This will Create an MDB File called Test an will create a Table Called Test Inside the MDB File.
  5. The Table will be filled with data from the Excel Sheet.
  6. References to ADO 2.0, ADOX 2.5, The Excel Object Library 9.0, and the Microsoft Data Binding Collection are required. If you have an Questions/Suggessions/comments, feel free to contact me through e-mail. My Address is eekumar@nestinfotech.com

Instructions: Click the link below to download the code. Select 'Save' from the IE popup dialog. Once downloaded, open the .zip file from your local drive using WinZip or a comparable program to view the contents.

Download exceltomdb.zip