How do I Import data that has more than 65535 rows of data? The follwoing code below is what I use to import data from excel to an access table , the problem I'm having is that I have 159000 rows of data and I'm being limited to import only 65535 rows in access. Is there way I can import the entire data?
Dim acc As New Access.Application
acc.CurrentDb.Execute "Delete * from tbl_EA"
Set acc = Nothing