Want to Export Access to Excel 2003
Hi friends,
I have large Excel worksheets (6 or 7 with 35000 - 48000 rows and up to 25 columns) imported into Access.
At the same time i am gettting an error message as
"The field is too small to accept the amount of data you attemted to add. Try inserting or pasting less data."
Now i again want back in Excel. I am using Office 2003.
Can anyone help me out with this isssue
Re: Want to Export Access to Excel 2003
Sure i will help you out did you try with a smaller data set, 100 lines or so, and work out which bit is causing the issue.
Re: Want to Export Access to Excel 2003
Yes i tried that also but it didn't worked out for me .
Re: Want to Export Access to Excel 2003
I was also having the same issue I tried with "Analyze In Excel" tool. I hope it will work for you.
Re: Want to Export Access to Excel 2003
Thanks a lot Ramchandra it worked for me. Thanks a lot i would really thankful to you.