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
srinvas831Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
srinvas831Connect With a Mentor Author 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
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.