Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Importing Excel Data into Access Database
- Thread starter PaulinKC
- Start date
You can use Office automation (which is free) but for decent performance and independence from specific versions of Office it might be easier to use one of the 3rd party .NET components that bypass Office and handle the .xls file directly.
Try I have used the Excel export component and achieved astonishing improvements in performance. I haven't actually tried the Excel reader component but if it's anything like the quality of the export component it will be excellent.
If you use Excel directly you will need to add a reference to the Officexx (11 for 2003?) COM component and then instantiate an Excel application object.
The Excel object model is not easy to follow if you've never used it before and it's too complex to describe in any detail. The key object you will need to understand is the Range object.
Bob Boffin
Try I have used the Excel export component and achieved astonishing improvements in performance. I haven't actually tried the Excel reader component but if it's anything like the quality of the export component it will be excellent.
If you use Excel directly you will need to add a reference to the Officexx (11 for 2003?) COM component and then instantiate an Excel application object.
The Excel object model is not easy to follow if you've never used it before and it's too complex to describe in any detail. The key object you will need to understand is the Range object.
Bob Boffin
- Status
