Export data from Access to Excel

[Sowjanya_N]

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;'

Please assist.

I need to export data to Access from excel having more than 65536 rows of data

[Hack]

Moved To Office Development

[Siddharth Rout]

I need to export data from Excel 2007 file to Access 2007 table.....
I need to export data to Access from excel having more than 65536 rows of data

You have me confused

You thread title say you want to export data from Access to Excel and your thread says the opposite... which one do you want?

Excel ~~>Access
OR
Access~~>Excel

[Hack]

Duplicate Threads Merged

Please do not create multiple threads, in different forum sections, for the same question.

[kaliman79912]

If the excel file has 65536 rows, why do you need to export more than that?