Solved

VB.net Create SQL Table from .csv file

Posted on 2015-01-15
4
276 Views
Last Modified: 2015-01-21
Hi

What VB.net code would I use to automatically create a SQL table from a .csv file?
Is it possible to create a blank table in this way?
0
Comment
Question by:murbro
  • 2
4 Comments
 
LVL 16

Accepted Solution

by:
Imran Javed Zia earned 334 total points
ID: 40552939
Hi,

You may read data from csv and based on datatype create sql script to create table.

alternatively you can also follow following article:
http://technet.microsoft.com/en-us/library/ms162203(v=sql.90).aspx

Thanks
0
 
LVL 16

Assisted Solution

by:Imran Javed Zia
Imran Javed Zia earned 334 total points
ID: 40552943
0
 
LVL 11

Assisted Solution

by:LordWabbit
LordWabbit earned 166 total points
ID: 40553345
If it's a once off import it might be easier to simply use the SQL Server import and export tools.
http://msdn.microsoft.com/en-us/library/ms140052.aspx
0
 

Author Closing Comment

by:murbro
ID: 40562670
Thanks for the help
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

920 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now