max # of rows that will paste into Access (1 Viewer)

[kidrobot]

Anyone know the answer? I'm testing something out but I'm using another querying tool to get the data which is greater than 65k (excels limit), so I can't import the data I have to manually copy/paste.

 

[RexesOperator]

If by rows you mean records, I've seen people here talk about millions of records. I don't think there is a limit.

 

[KKilfoil]

If you have a file containing >65K records, why don't you try importing this DIRECTLY into Access as a table? Access supports a variety of file formats, and comes with a wizard to assist with most straightforward data layouts.

 

[Moniker]

In other words, instead of using your "other querying tool" to export into Excel, export it into a CSV file and import that directly into Access.

Just as an FYI, Excel 2007's last row is 1048576. The 65KB limit is gone.