I need to export data from Excel 2007 file to Access 2007 table.
The excel file has 65536 rows and I am not able to export more than 65536 rows of data.
Here is the code
con= "Provider=Microsoft.ACE.OLEDB.12.0;Data Source='" & DBName & "';"
sql1= "INSERT INTO table SELECT * FROM [Sheet1$] IN '" & ThisWorkbook.FullName & "' 'Excel 12.0;'
I need to export data to Access from excel having more than 65536 rows of data