Copy SQLite query results to dBase table

Want to transfer data from SQLite query results to dBase table?

Try Withdata DBCopier, a SQLite to dBase converter for Windows, Mac, and Linux, Copy SQLite query to dBase, Easy and Fast.

• Can run in GUI mode, Step by Step, just a few mouse clicks.
• Can run in Command line, for Scheduled Tasks and Streams.
• Support Windows, Linux, and macOS.

Download Withdata DBCopier
Windows 64 bit
Windows 32 bit
Linux .deb (For Debian, Ubuntu) 64 bit
Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit
MacOS 64 bit

Transfer data from SQLite query To dBase table

Login to SQLite and dBase -> Enter source SQLite query -> Set target dBase table -> Copy SQLite query data to dBase table

Choose source SQLite database and logon.

Choose target dBase database and logon.

Click “Convert From Query” at task dialog.

then show the wizard.

1. Set a SQLite query.

2. Select a destination dBase table and config fields.

3. Preview data.

4. Transfer data from SQLite query result to dBase table.

---

More about SQLite to dBase converter

See also:

• Copy SQLite table data to dBase
• Merge multiple similar SQLite tables to 1 dBase table
• Batch copy SQLite tables to dBase

SQLite → dBase reference

Type mapping

Value kind	in SQLite	in dBase
Int	INTEGER	Numeric(10,0)
Bigint	INTEGER	Numeric(19,0)
Decimal	NUMERIC	Numeric(p,s)
Float	REAL	Float
Text	TEXT	Character(n)
Long text	TEXT	Memo
Date	TEXT	Date
Datetime	TEXT	(none)
Binary	BLOB	(none)
Boolean	INTEGER	Logical

Dialect differences

Both SQLite and dBase are database servers, so the differences below are dialect-level: the same concept is spelled differently on each side.

Property	in SQLite	in dBase
identifiers	"double quotes" or [brackets]	—
row limit	LIMIT n	(driver dependent)
dates	TEXT (no date type)	Date (D)
long text	TEXT	Memo (M)
binary	BLOB	—

Command line

Side	Command
SQLite	sqlite3 .dump
SQLite (load)	.import (sqlite3)

No counterpart

• SQLite values of kind Date and time have nowhere to go in dBase.
• SQLite values of kind Binary have nowhere to go in dBase.
• SQLite values of kind JSON have nowhere to go in dBase.

Convert your data online, free

Free in-browser converters for CSV, Excel, JSON, XML and SQL: Withdata Online Data Conversion. Large files, batch conversion or scheduling? See the offline desktop apps, or browse all data conversion tools.