Problem importing excel 2003 file into ms access 2003 database table using ASP forms
Posted on 2004-11-12
create an ASP page that uploads an ms excel 2003 file. Once file is uploaded create another ASP page with an import button, when the button on the form is pressed the server will read the just uploaded excel 2003 file then import the data into an ms access 2003 database table located at the server, as a way to assure that data import worked succesfully have the same ASP page notify that import was succesfull and it should show how many records were succesfully imported into database.
Current File Structure:
MS Excel 2003 File - with 15 columms and 75 rows, some fields on the rows contain no data
MS Access 2003 database table with field names exactly the same as on the excel file.
I had figured out all this by using a CSV file instead of the excel file but the problem was that due to the csv file having some cell with no data the import would work fine on the cells with data but it would fail on the empty cells by returning an error message on the ASP page about values on the csv not matching the number of field on the database.
I have reviewed 2 other postings on this website about a similar issue, but none seemed to resolve the problem. Any help would be appreciated!