Community
Showing results for 
Search instead for 
Do you mean 
Reply

Object Reference not set to an instance of an object when trying to import an excel file

Accepted Solution Solved
Copper Super Contributor
Posts: 44
Country: USA
Accepted Solution

Object Reference not set to an instance of an object when trying to import an excel file

Hi 

When trying to import an excel file into Act Premium web version 192.2.146.0 update1 on our server using the wizard we are getting this error

Object Reference not set to an instance of an object.  

What can be done to fix please?


Accepted Solutions
Solution
Accepted by topic author shari@sfadvance.com
‎09-20-2017 06:24 AM
Copper Super Contributor
Posts: 44
Country: USA

Re: Object Reference not set to an instance of an object when trying to import an excel file

Thank you that worked!

View solution in original post


All Replies
Bronze Elite Contributor
Posts: 1,430
Country: United_Kingdom

Re: Object Reference not set to an instance of an object when trying to import an excel file

This horrible error message is very unhelpful as it can mean so many things BUT

 

Please check you have closed the spreadsheet - You cannot import from an open Excel sheet.

Copper Super Contributor
Posts: 44
Country: USA

Re: Object Reference not set to an instance of an object when trying to import an excel file

Yes spread sheet was closed.  Infact we copied to server and trying to import file on the server

Employee
Posts: 117
Country: USA

Re: Object Reference not set to an instance of an object when trying to import an excel file

Maybe there are some hidden formats in the spreadsheet causing issues such as merged cells.
The quickest solution to get rid of things of this nature is to save it as a csv file.
Csv files have no unusual formats.

You can convert an Excel worksheet to a text file by using the Save As command.
  1. Go to File > Save As.

     

    The Save As dialog box appears.

  2. In the Save as type box, choose the text file format for the worksheet. 

    CSV (Comma delimited).

     

  3. Browse to the location where you want to save the new text file, and then click Save.

  4. A dialog box appears, reminding you that only the current worksheet will be saved to the new file. If you are certain that the current worksheet is the one that you want to save as a text file, click OK. You can save other worksheets as separate text files by repeating this procedure for each worksheet.

  5. A second dialog box appears, reminding you that your worksheet may contain features that are not supported by text file formats.click Yes.

 

 

With the csv file closed import text file rather than the spreadsheet into Act!

 

Copper Super Contributor
Posts: 44
Country: USA

Re: Object Reference not set to an instance of an object when trying to import an excel file

With the csv file I am getting line must be a least 2 chars parameter name line  - I have attached the file

Employee
Posts: 117
Country: USA

Re: Object Reference not set to an instance of an object when trying to import an excel file

 

It may be the carriage returns in the header formulas (the extra space before and after any words)
I suggest removing them.
Drag the space of the formula bar down and it is easier to see it.

example.png

 

 

 

Bronze Elite Contributor
Posts: 1,430
Country: United_Kingdom

Re: Object Reference not set to an instance of an object when trying to import an excel file

Just to agree with Carl. ACT will reading this as no Header in those columns.

Solution
Accepted by topic author shari@sfadvance.com
‎09-20-2017 06:24 AM
Copper Super Contributor
Posts: 44
Country: USA

Re: Object Reference not set to an instance of an object when trying to import an excel file

Thank you that worked!