Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 1.0 and 1.1 > ASP.NET 1.0 and 1.1 Basics
ASP.NET 1.0 and 1.1 Basics ASP.NET discussion for users new to coding in ASP.NET 1.0 or 1.1. NOT for the older "classic" ASP 3 or the newer ASP.NET 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 1.0 and 1.1 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old October 4th, 2006, 04:54 AM
Authorized User
Join Date: Oct 2006
Posts: 63
Thanks: 0
Thanked 0 Times in 0 Posts
Default Importing Excel sheet into Access using ASP

Hi Frnds,

I am importing data from excel to access using ASP.
But at the time of importing I am facing some problem. Let me discuss elaborately.
Say I am having one data in excel sheet. After inserting the data into database an error is occurring, saying, “Primary index cannot be null”.
I can understand that the error is occurring due to the next field in excel sheet, which is NULL. Can I restrict this error by someway?

Anybody please help me.


Old October 5th, 2006, 02:36 PM
Wrox Author
Join Date: Oct 2005
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons

The only way you can restrict the error is by dropping your Primary Key definitions on your columns and then you can insert NULL data at will.

This is a design flaw though, because if you have an index the data should NEVER be null. Anyway, dropping the keys will allow you to insert the data.

--Stole this from a moderator

I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

Similar Threads
Thread Thread Starter Forum Replies Last Post
access to excel sheet conversion? ramniwas Visual Basic 2005 Basics 2 April 6th, 2008 08:38 AM
importing excel data into access forms navdeepsinghparmar Access 1 November 7th, 2007 01:27 PM
Importing from Excel to Access table DeborahP Excel VBA 3 April 3rd, 2007 03:21 AM
Importing data from excel sheet to databaase jvraman SQL Server 2000 3 May 12th, 2006 12:00 AM
access data of excel sheet into sql server in asp KGANESH2006 SQL Server ASP 2 April 20th, 2006 02:33 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.