Results 1 to 4 of 4
  1. #1
    itsmemike is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2010
    Posts
    8

    Problem with Excel import

    Good day


    It says I have exceeded the 225 field limit but what it is doing is importing empty fields from the work sheet. Can anyone tell me how to over come this. The spread sheet is only 23 fields.
    regards
    Mike

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Are you using the TransferSpreadsheet and are you using the Range argument?

  3. #3
    itsmemike is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2010
    Posts
    8
    no I just import for excel,I am new to access so I just followed the instructions

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    So it is a manual import?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Import from Excel
    By Jonathan58 in forum Import/Export Data
    Replies: 18
    Last Post: 07-19-2013, 09:52 AM
  2. Excel import using VBA
    By catguy in forum Programming
    Replies: 6
    Last Post: 08-25-2010, 09:58 AM
  3. Excel Import
    By jesleon in forum Import/Export Data
    Replies: 4
    Last Post: 08-24-2010, 07:32 AM
  4. Import Excel with SQL - again
    By tpcervelo in forum Queries
    Replies: 1
    Last Post: 08-06-2010, 08:13 PM
  5. VBA to open excel, import on close of excel
    By bdaniel in forum Programming
    Replies: 0
    Last Post: 03-20-2010, 02:45 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums