eekhpang
asked on
utility to import from dbase III dbf into MS sql server 6.5
any utility available to import dbaseIII dbf files into MS sql server 6.5?
Can bcp do the task?
Can bcp do the task?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
There is a XP that comes with SQL server that can
directly read a DB III file. However it has some limit. It has
numrecords defined as short that means it would only work
to tables with numrecords<32768. Fix this by opening
the source code in C ++ and redim the variable to long
and recompile the DLL.