srinvas831
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.