Want to Export Access to Excel 2003

[Darsheet]

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

[WaGoN]

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.

[Darsheet]

Yes i tried that also but it didn't worked out for me .

[Ramchandra]

I was also having the same issue I tried with "Analyze In Excel" tool. I hope it will work for you.

[Darsheet]

Thanks a lot Ramchandra it worked for me. Thanks a lot i would really thankful to you.