Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
simondeutsch
Aged Yak Warrior
547 Posts |
 Posted - 2002-10-30 : 14:26:45
|
| Anyone know how to import a dBase 3 memo field's contents (uses a pointer) into a SQL Server 7 TEXT field?Sarah Berger MCSD |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-10-30 : 14:35:39
|
Prayer.  If the ODBC or OLE DB driver doesn't handle it automatically, I'd say you're SOL. You *might* be able to link the DBF file to an Access database and Access might be able to read the memo field, then you can link to the SQL Server tables and do an INSERT that way. I *think* Excel will import the memo into a worksheet, but it's been a long time since I've tried it.If you know a little VFP you can probably convert the DBF into a more usuable format. |
 |
|
|
|
|
|
Import .dbf memo field into SQL TEXT field