Exporting scanned data to dBase V 1

[dianasmi]

I am trying to use Teleforms scanning software to export scanned data into dBase V. After about the 20th record exports to my dBase file, I get the error message: dbase database ***.dbf already exists. Teleforms tech support thinks my dbase file is locking out for some reason, as if another application is using the same dbase file (which is not the case) I have my time out settings at 60 on my dbase odbc driver, which seems high enough? An export to dbase V will work using this system, but only in very small batches (20 records or less), otherwise I get the error message. Any ideas???

 

[MiggyD]

Dianasmi;

Although I currently work with DB3+ and my employer is a Scrooge decendant; my only suggestion is (if it is possible) scan the file and save as a text file then use the

APPEND FROM myfile.txt DELIMITED [[red]WITH BLANK[/red] ]\[[red]CharThatDelimits ex: ","[/red]].

It should work in DB5 (hopefully). <fingers crossed>

Also, did you check your help files for APPEND FROM to see if this function is supported in 5? It's worth a shot.

If this works, please come and post a response.

--MiggyD &quot;The world shrinks more and more with every new user online.&quot;

 

[dianasmi]

The append text file command works great, however my data does not end up in the correct field names. I have many old field names in my existing dbase file, that will not have new data added to them, and that is why i was trying to export directly to my dbase file, to get everything in the correct field name.

I'll keep trying. I have come across something about odbc 32-bit drivers on windows 95 and 98 and the thunking layer (which of course I have no idea what that is)and problems with 16-bit applications. Maybe that is part of my problem? I am on Windows 95.

thanks for the help

 

[MiggyD]

Dianasmi:

Glad it helps some.

Don't know if you can use this command in 5, but in 3+ you would be able to copy the structure of the existing db to a seperate (and entirely new) db file with only the fields you want.

Here's a snapshot of the Help documentation in 3+....
[tt]


COPY
----


Syntax : COPY TO <new file> [<scope>] [FIELDS <field list>] [FOR <cond>]
[WHILE <cond>] [[TYPE] <file type>] /
[DELIMITED [WITH BLANK/<delimiter>]]
[red]COPY STRUCTURE TO <new file> [FIELDS <field list>][/red]

Description : Duplicates all or part of the active database file to
a specified database file or, if you use the TYPE or DELIMITED
options, to a foreign or text file respectively. COPY
STRUCTURE creates a duplicate of the structure of the database
file in USE. COPY STRUCTURE EXTENDED creates a new database
with 4 fields: field name, type, length and number of decimals,
the contents of which are field names, etc... of the old file.


HELP ¦<C:>¦ ¦ ¦ ¦Num
Previous screen - PgUp. Previous menu - F10. Exit with Esc or enter a command.[/tt]



It would look like this:

COPY STRU TO newFile.dbf FIELDS fieldNum1, fieldNum3, fieldNum2, fieldNum4

Notice that the fileds will be rearranged in the NEW dbf file in the manner they were copied.

Don't forget to have the dbf you want to COPY FROMalready opened, BEFORE you use the COPY STRUCTURE command--if not already opened it'll ask you for the name.

Good Luck,
--MiggyD &quot;The world shrinks more and more with every new user online.&quot;