Improve company productivity with a Business Account.Sign Up

x
?
Solved

Exporting Ms Access data to CSV using C#

Posted on 2008-06-14
7
Medium Priority
?
273 Views
Last Modified: 2010-04-28
Hi I am trying to export ms access data to CSV using C#. I have a problem with capturing its foreign key enforcement and check constraints. I can find codes for exporting csv to access but the otherwise. I am new here. Can anyone kindly share with me? Thanks
0
Comment
Question by:Jaded25
  • 3
  • 2
5 Comments
 
LVL 31

Expert Comment

by:Alexandre Simões
ID: 21788484
Hi,
why don't you just create a view on Access with the data and schema you want to export to CSV and then just make a loop on C# that concatenates the cell values of each row separated by ';'  ?

Each loop would do a WriteLine to the StreamWriter of the concatenated strings... that's it... :)
0
 

Author Comment

by:Jaded25
ID: 21788555
Thanks for your help. Would it be alright if I want to know the code? Thanks :)
0
 
LVL 31

Accepted Solution

by:
Alexandre Simões earned 2000 total points
ID: 21788620
I was going to write it but decided to do a little google search first so here's a sample code of it:

http://dotnetguts.blogspot.com/2007/01/exporting-datatable-to-csv-file-format.html

I'm attaching the same code but better formatted and I changes the sparator from ',' to ';'
This is just because if you have numeric values and depending on your region the comma may be a problem.

cheers
using System;
using System.Data;
using System.IO;
 
namespace WorkBench
{
	public static class WriteCSVDemo
	{
 
		public static void  CreateCSVFile(DataTable dt, string strFilePath)
		{
 
 
			#region Export Grid to CSV
 
			// Create the CSV file to which grid data will be exported.
			StreamWriter sw = new StreamWriter(strFilePath, false);
 
			// First we will write the headers.
			int iColCount = dt.Columns.Count;
 
			for (int i = 0; i < iColCount; i++)
			{
				sw.Write(dt.Columns[i]);
				if (i < iColCount - 1)
				{
					sw.Write(";");
				}
			}
 
			sw.Write(sw.NewLine);
 
			// Now write all the rows.
			foreach (DataRow dr in dt.Rows)
			{
				for (int i = 0; i < iColCount; i++)
				{
					if (!Convert.IsDBNull(dr[i]))
					{
						sw.Write(dr[i].ToString());
					}
					if (i < iColCount - 1)
					{
						sw.Write(";");
					}
				}
 
				sw.Write(sw.NewLine);
			}
 
			sw.Close();
 
			#endregion
 
		}
 
	}
}

Open in new window

0
 

Author Comment

by:Jaded25
ID: 21788930
Thanks you so much for the help.
0
 
LVL 31

Expert Comment

by:Alexandre Simões
ID: 21788950
Glad I could help,

Cheers!
0

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…

579 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question