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
Solved

VB.net Create SQL Table from .csv file

Posted on 2015-01-15
4
287 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
vb.net help 4 34
get row value in vb.net 4 18
Help with preventing selection from a combobox 11 34
How to repeat the data 4 18
If you're writing a .NET application to connect to an Access .mdb database and use pre-existing queries that require parameters, you've come to the right place! Let's say the pre-existing query(qryCust) in Access takes a Date as a parameter and l…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

829 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