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
Reverend Jim 4,968 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,968 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.