Results 1 to 5 of 5

Thread: Want to Export Access to Excel 2003

  1. #1
    Join Date
    Dec 2008
    Posts
    97

    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

  2. #2
    Join Date
    Dec 2008
    Posts
    182

    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.

  3. #3
    Join Date
    Dec 2008
    Posts
    97

    Re: Want to Export Access to Excel 2003

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

  4. #4
    Join Date
    Dec 2008
    Posts
    152

    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.

  5. #5
    Join Date
    Dec 2008
    Posts
    97

    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.

Similar Threads

  1. export details in active directory to Access 2003
    By hz84 in forum Active Directory
    Replies: 1
    Last Post: 21-05-2011, 06:56 AM
  2. Export from MS Project 2003 to Excel 2007
    By Taksal in forum Microsoft Project
    Replies: 4
    Last Post: 08-04-2010, 11:51 AM
  3. To export an access table definition into Excel
    By bhola in forum Windows Software
    Replies: 3
    Last Post: 03-09-2009, 05:54 PM
  4. Export Excel 2003 sheet in csv Format
    By BADRU in forum Windows Software
    Replies: 3
    Last Post: 06-04-2009, 10:23 PM
  5. How to export a Project 2003 file into Excel 2003
    By destinyswarrior in forum Windows Software
    Replies: 3
    Last Post: 21-03-2009, 05:45 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,643,441,829.24169 seconds with 17 queries