P
Peter Green
Guest
Why is it so difficult to transfer whole Excel sheets over to Access?
I keep getting a message: too many records to edit.
Plaese help. Thanks
Why is it so difficult to transfer whole Excel sheets over to Access?
I keep getting a message: too many records to edit.
Plaese help. Thanks
M
mission2java_78
Guest
Peter Green said:
Why is it so difficult to transfer whole Excel sheets over to Access?
I keep getting a message: too many records to edit.
Plaese help. Thanks
Huh?
What are you transfering over the data to tables?
Can you post your project or code. Are you using the excel object model?
Jon
P
Peter Green
Guest
I'm really not doing anything fancy. I simply want to copy and paste a whole Excel worksheet over into Access. Access is only letting me do it one record in a table or design view at a time. Why is this happening? (See attached File)
However, I discovered I can achieve my result by highlighting and dragging my information from Excel over into Access. This works but it's sloppy. Especially since I have to make a dummy copy of my existing Excel sheet to copy, cut drag and click. Any further insight would be appreciated.
Thank you.
However, I discovered I can achieve my result by highlighting and dragging my information from Excel over into Access. This works but it's sloppy. Especially since I have to make a dummy copy of my existing Excel sheet to copy, cut drag and click. Any further insight would be appreciated.
Thank you.
M
mission2java_78
Guest
Peter Green said:
Where's the attached file?
Jon
ghudson
Registered User.
- Local time
- Today, 10:13
- Joined
- Jun 8, 2002
- Messages
- 6,193
Have you tried importing your data from Excel into Access? I suggest that you try the TransferSpreadsheet method. Check the help files for TransferSpreadsheet for more info and examples on how to import your data.
HTH
HTH
