Writing a dataset into an access file

		Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Writing a dataset into an access file

Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access 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

March 12th, 2004, 10:01 AM

pankaj_daga pankaj_daga is offline

Authorized User

Join Date: Sep 2003

Posts: 83

Thanks: 0

Thanked 0 Times in 0 Posts

Writing a dataset into an access file

Hi everyone,

I am using ADO.NET with Access. I have a dataset filled from a data source which has one-to-one correspondance with an Access table. I would like to know what is the most efficient way to fill the Access table with this dataset. Should I iterate through the dataset and call SQL inserts?? I am hoping there is a better way.

Thank you for any help you might give me.

Sincerely,

Pankaj

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Writing to Excel from a dataset with VB.Net	ruairi	VB.NET 2002/2003 Basics	5	July 27th, 2009 12:07 PM
writing into a file in linux file system	anboss	XSLT	6	June 19th, 2008 01:56 PM
Exporting dataset to an Access File	sujith_gokul	ADO.NET	0	December 8th, 2005 03:57 AM
Re: SQL Server dataset to ACCESS dataset	dazzer	ADO.NET	0	March 22nd, 2004 05:28 AM
Writing a dataset into an access file	pankaj_daga	ADO.NET	10	March 16th, 2004 10:37 AM