Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 09-06-2009
Member
 
Join Date: May 2009
Posts: 199
Excel: error 'subscript out of range' while importing spreadsheet

I tried to import a spreadsheet to Access from one of my Excel workbook. I was unable to do that and excel gives the pop up with the following error "subscript out of range". What is that and how can i fix this problem ?
Reply With Quote
  #2  
Old 09-06-2009
Member
 
Join Date: Apr 2008
Posts: 4,641
Re: Excel: error 'subscript out of range' while importing spreadsheet

The problem might be that the wizard doing the import has a limit on the number of fields it can import.The problem is definitely not with Access, its with Excel. Try importing the excel to a new table and double check the field formats access assigned. Also delete all empty columns and rows.Deleting the empty columns and/or rows restores them to a "pristine" condition. Or try entering a ZERO in each blank field. to do that, enter a 1 in a blank cell on another sheet, COPY the cell, select the date column, Edit>Paste Special - MULTIPLY. The delete the ROWS below the table that do not contain data but have ZEROS in the date column.
Reply With Quote
  #3  
Old 09-06-2009
Member
 
Join Date: Feb 2009
Posts: 113
Re: Excel: error 'subscript out of range' while importing spreadsheet

You can try to import the spreadsheet in the CSV format.Delete all empmty rows and columns. You might also try ensuring that the Excel spreadsheet does not include any illegal fieldnames as header rows. Check for the use of special characters, such as apostrophes, colons, etc. in the header row in Excel.
Reply With Quote
  #4  
Old 09-06-2009
Member
 
Join Date: May 2008
Posts: 4,565
Re: Excel: error 'subscript out of range' while importing spreadsheet

What i can suggest you is simply remove all blank columns and rows Or import it manually. Select excel file to import, click next and you will get error. Now on the next screen just checkout the data and verify the columns. Here scroll left till end. There might be extra columns which is causing this problem.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Excel: error 'subscript out of range' while importing spreadsheet"
Thread Thread Starter Forum Replies Last Post
Microsoft Office Excel cannot create or use the data range reference because it is too complex Error Finian-- MS Office Support 4 31-12-2011 06:11 PM
Can We Auto-Run Excel Spreadsheet.?? Dilbert Windows Software 4 02-01-2010 09:09 PM
Importing Excel Spreadsheet Theodore Long Microsoft Project 3 05-06-2009 09:02 AM
Error while importing data to excel file Rutajit Windows Software 3 07-05-2009 11:38 PM
Importing HTML table in a Spreadsheet - Excel 2007 Aarif Tips & Tweaks 1 01-12-2008 02:35 PM


All times are GMT +5.5. The time now is 07:37 PM.