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
Rick RudolphAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Rick RudolphAuthor 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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Rick RudolphAuthor 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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.

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.