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

Problem in importing data from text file into SQL Server 2008

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
srinvas831
Asked:
srinvas831
1 Solution
 
srinvas831Author Commented:
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

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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