Hi All,
I am trying to create a VB application where I will have to upload the Excel data into MS access automatically, can anyone suggest me a method as how to do it?
Regards,
Srinivas
Srinivas_2
0
Newbie Poster
Recommended Answers
Jump to PostThat would depend on the format of the data. It is possible to connect to an Excel spreadsheet as an ADODB data source but there are certain conditions. What is the format of your spreadsheet?
All 3 Replies
Reverend Jim
4,780
Hi, I'm Jim, one of DaniWeb's moderators.
Moderator
Featured Poster
That would depend on the format of the data. It is possible to connect to an Excel spreadsheet as an ADODB data source but there are certain conditions. What is the format of your spreadsheet?
Srinivas_2
0
Newbie Poster
The format is just normal Excel file (.xlsx). The columns are String and number.
Reverend Jim
4,780
Hi, I'm Jim, one of DaniWeb's moderators.
Moderator
Featured Poster
I just posted a sample in the Code Snippets with the title How to read an Excel spreadsheet using ADODB. Have a look and see if that helps.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.