Link to home
Start Free TrialLog in
Avatar of srinvas831
srinvas831Flag for India

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of srinvas831
srinvas831
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial