• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2088
  • Last Modified:

Importing data into a table in Visual Studio Express 2013 from a comma delimited File

I am trying to to bulk insert some data into some local tables in Visual Studio, have tried to follow a number of different tutorials, but get a variety of error messages.

I was hoping to do this with SQL, but I am somewhat familiar with visual basic as well.

I will need to do this with a number of tables, but one example should hopefully get me on my way.
VSStudioScreenShot.JPG
AJEWORK.txt
0
rrudolph
Asked:
rrudolph
  • 3
  • 2
1 Solution
 
Ammar GaffarSoftware EngineerCommented:
Dear rrudolph,

The easiest and fastest way is using the import data wizard from SQL Management Studio. It is simple, straight forward and accurate.

You check this tutorial:
http://www.youtube.com/watch?v=kCT_t8p0aEw

Good Luck
0
 
rrudolphAuthor Commented:
Thanks, I am trying to import data from the text file to Visual Studio, and when I run the import wizard, the first part seems fine, but I never see where I can connect to the TBCO_Journal_Entries.mdf.AJEWork Table. This should actually be an append
0
 
Ammar GaffarSoftware EngineerCommented:
When you add database locally from Visual Studio.NET the instance will be: (localdb)\V11.0 , that is why you cannot see your database listed when you connected to your database server default instance using SQL Management Studio.

To import and export data in your scenario, and when you reach Choose a Destination Page in Import & Export Wizard, the default server name is: (local), just change it to : (localdb)\V11.0 then your database will be listed there choose it and follow the rest of tutorial.

Good Luck
0
 
Ammar GaffarSoftware EngineerCommented:
One more thing, instance name : (localdb)\V11.0 is valid if you are using SQL Server 2012, you can get the actual instance if you are using different version is by right click on your database in Server Explorer and click on Browse in SQL Server Object Explorer, the instance name will be the root node in this explorer.
0
 
rrudolphAuthor Commented:
My tables are in an mdf files, I know the path to that. Does that change your response? This is a local database integrated into Studio 2013. The database will never be large, and I want to be able to distribute a small windows app without dealing with separate SQL issues
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now