?
Solved

VB.net Create SQL Table from .csv file

Posted on 2015-01-15
4
Medium Priority
?
323 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:Murray Brown
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 16

Accepted Solution

by:
Imran Javed Zia earned 1336 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 1336 total points
ID: 40552943
0
 
LVL 11

Assisted Solution

by:LordWabbit
LordWabbit earned 664 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:Murray Brown
ID: 40562670
Thanks for the help
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

Article by: Kraeven
Introduction Remote Share is a simple remote sharing tool, enabling you to see, add and remove remote or local shares. The application is written in VB.NET targeting the .NET framework 2.0. The source code and the compiled programs have been in…
Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

719 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