VB.net Create SQL Table from .csv file

Posted on 2015-01-15
Medium Priority
Last Modified: 2015-01-21

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?
Question by:Murray Brown
  • 2
LVL 16

Accepted Solution

Imran Javed Zia earned 1336 total points
ID: 40552939

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

alternatively you can also follow following article:

LVL 16

Assisted Solution

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

Assisted Solution

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.

Author Closing Comment

by:Murray Brown
ID: 40562670
Thanks for the help

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.

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

I think the Typed DataTable and Typed DataSet are very good options when working with data, but I don't like auto-generated code. First, I create an Abstract Class for my DataTables Common Code.  This class Inherits from DataTable. Also, it can …
Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
Watch the video of Kernel Migrator for SharePoint, which demonstrate the process easily of migration from SharePoint to SharePoint, OneDrive for Business & Google Drive servers, Public Folder to SharePoint, File Server to SharePoint. The tool has va…
Watch the video to know the simple way to remove or recover or reset lost or forgotten passwords of Outlook PST file. With Kernel Outlook Password Recovery tool such operation is very easy to perform. It is a freeware with limitation to use with 500…
Suggested Courses

623 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