• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 301
  • Last Modified:

Recordset Limits

I am running a record set which simply stops after importing circq 17000 records from an excel file.

If i shorten the file it works fine.

Is there a limit in time or size for importing through a recordset?

all help most welocme.
1 Solution
Jeffrey CoachmanMIS LiasonCommented:
Try just using code in Access to import the data:
DoCmd.TransferSpreadsheet acImport, , TargetTableName, "C:\YourFolder\Yourfile.xls"
Dale FyeCommented:
Can you provide more details about how you are trying to do this?  your code?  Do you have error handling in your code?

Have you tried just linking to the spreadsheet rather than importing it?  Importing from Excel can be problematic in that Access attempts to determine the correct data type for each column and occasionally (more frequently that I would like), it does it wrong.
Post your code please.  Perhaps you have selected an old version of Excel in the TransferSpreadsheets method.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now