Selecting and Importing Excel File and Sheet for import into Access

Clifford Nelson

Rate me:

5.00/5 (6 votes)

7 Sep 2018CPOL4 min read

24.3K

1.5K

This is a tip that has the code for selecting an Excel file and sheet for import into Microsoft Access. This includes the code required to browse for a file, and populate a ListBox with the sheets of the Excel Workbook, and the code to import an Excel spreadsheet.

Views

Daily Counts

Downloads

Weekly Counts

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Clifford Nelson

Software Developer (Senior) Clifford Nelson Consulting

United States

Has been working as a C# developer on contract for the last several years, including 3 years at Microsoft. Previously worked with Visual Basic and Microsoft Access VBA, and have developed code for Word, Excel and Outlook. Started working with WPF in 2007 when part of the Microsoft WPF team. For the last eight years has been working primarily as a senior WPF/C# and Silverlight/C# developer. Currently working as WPF developer with BioNano Genomics in San Diego, CA redesigning their UI for their camera system. he can be reached at qck1@hotmail.com.

Selecting and Importing Excel File and Sheet for import into Access

Views

Downloads

License

Comments and Discussions