Importing xls into Sql Db via Coldfusion

Hello Experts,
 
I am having a hard time solving this issue, the code below is used to import the data from an excel spreadsheet into a SQL DB,  the code works fine, except when there is a blank cell in the spreadsheet, the ,, in the csv file is not recognised as a value and is skipped resulting in an element being undefined. an example of this is the spreadsheet has an address1 and an address2  field, all entries have an addess1 value though some entries do not have an address2 entry depending weather or not there is a unit or suite number. I have tried different things to remedy this with no success. The issue can be resolved by simply changing the csv file (value1,value2,,value4 to value1,value2, ,value4. Notice the space in the commas between value 2 and 4) but it is not preferred to leave this in the shippers hands. Any help will be appreciated

the Code

<cffile action="READ"
      file="c:\temp\address.csv"
            variable="csvfile">

<!--- loop through the CSV-TXT file on line breaks and insert into database --->



<cfloop index="index" list="#csvfile#" delimiters="#chr(10)##chr(13)#" >
 <cfquery name="importcsv" datasource="#dsn#">
         INSERT INTO Table (Name,Company,Address1,Address2,City,State,zip,phone)
         VALUES
                  ('#listgetAt('#index#',1, ',')#',
                   '#listgetAt('#index#',2, ',')#',
                   '#listgetAt('#index#',3, ',')#',
                   '#listgetAt('#index#',4, ',')#',
                   '#listgetAt('#index#',5, ',')#',
                   '#listgetAt('#index#',6, ',')#',
                   '#listgetAt('#index#',7, ',')#',
                   '#listgetAt('#index#',8)#'
                  )
   </cfquery>
</cfloop>

<!--- use a simple database query to check the results of the import - dumping query to screen--->
<cfquery name="csvimport" dbtype="text/html" datasource="#dsn#">
         SELECT * FROM table
</cfquery>
<cfdump expand="yes" var="#rscsvdemo#">