Solved

Problem in importing data from text file into SQL Server 2008

Posted on 2013-05-23
1
410 Views
Last Modified: 2013-05-24
Hi Guys,

I used to run some stored procedures in SQL Server 2000. I used to save the output data in .txt file. Then I used to import the data from the text file into MS Access Database file.

But due to upgradation of my OS from Windows XP to Windows 7, I had to run those stored procedures in SQL Server 2008 now. I tries to repeat the same process mentioned above. But, after importing the data into MS access database, the very first record in the text file is imported with a tab appended before it.

Please find the attached image for better understanding.
Please provide your suggestions.
Thanks in advance
IMAGE-65EEC430C67344F9.jpg
0
Comment
Question by:srinvas831
[X]
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
1 Comment
 

Accepted Solution

by:
srinvas831 earned 0 total points
ID: 39193769
Problem resolved..
We need to save the text file in ANSI encoded format to avoid the appending of tab..
while importing into access..
0

Featured Post

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

738 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