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

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?

The format is just normal Excel file (.xlsx). The columns are String and number.

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.