May 17, 2002 at 10:38 am
Hello All 🙂
Has anyone gone into the data migration of DBF files into SQL Server 2000?
Do I have to export the DBF to TXT files or I can just read the DBF format?
In addition, can SQL Server 2000 read AccPac Accounting data?
Any insights are HIGHLY appreciated
Maher
MB
May 17, 2002 at 10:46 am
DTS will let you import DBF files with no problem. Not sure what file format the accounting software uses. If its one of the ones supported by DTS you can do it directly, otherwise you'll have to export it out of the account software to a file format you can use.
Andy
May 17, 2002 at 10:55 am
DBF should be FoxPro which SQL supports already.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 19, 2002 at 5:44 pm
It can be also for dbf files as used by Clipper
When you select from the list of available connection type you have dBase III, dBase IV and dBase5.
I used dBase III for Clipper files.
Cheers
Tom
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply