VB.net Create SQL Table from .csv file

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?
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
Imran Javed ZiaConnect With a Mentor Consultant Software Engineer - .NET ArchitectCommented:
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
 
Imran Javed ZiaConnect With a Mentor Consultant Software Engineer - .NET ArchitectCommented:
0
 
LordWabbitConnect With a Mentor Commented:
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
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks for the help
0
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.

All Courses

From novice to tech pro — start learning today.