Impoting Excel file into Access Database using ASP

		Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 1.0 and 1.1 > ASP.NET 1.0 and 1.1 Professional
Impoting Excel file into Access Database using ASP

ASP.NET 1.0 and 1.1 Professional For advanced ASP.NET 1.x coders. Beginning-level questions will be redirected to other forums. NOT for "classic" ASP 3 or the newer ASP.NET 2.0 and 3.5

Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 1.0 and 1.1 Professional 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

October 5th, 2006, 02:39 AM

prasanta2expert prasanta2expert is offline

Authorized User

Join Date: Oct 2006

Posts: 63

Thanks: 0

Thanked 0 Times in 0 Posts

Impoting Excel file into Access Database 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.

Prasanta

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Exporting form Access Database to Excel	asters	VB.NET 2002/2003 Basics	5	April 13th, 2007 02:23 PM
how to transfer data from excel to Access database	swaroop	Access VBA	5	April 13th, 2007 09:02 AM
Excel To Access Database	KennethMungwira	Excel VBA	3	November 16th, 2006 06:49 AM
Import Excel File to access database	Komila	ASP.NET 1.0 and 1.1 Professional	7	October 7th, 2006 12:45 AM
Exporting access database to Excel .xls	Squall Leonhart	Classic ASP Databases	5	December 2nd, 2003 07:42 PM