Copy DBF query results to Access table

Want to transfer data from DBF query results to Access table?

Try Withdata DBCopier, a DBF to Access converter for Windows, Mac, and Linux, Copy DBF query to Access, 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 DBF query To Access table

Login to DBF and Access -> Enter source DBF query -> Set target Access table -> Copy DBF query data to Access table

Choose source DBF database and logon.

Choose target Access database and logon.

Click “Convert From Query” at task dialog.

then show the wizard.

1. Set a DBF query.

2. Select a destination Access table and config fields.

3. Preview data.

4. Transfer data from DBF query result to Access table.

---

More about DBF to Access converter

See also:

• Copy DBF table data to Access
• Merge multiple similar DBF tables to 1 Access table
• Batch copy DBF tables to Access

DBF → Access reference

Type mapping

Value kind	in DBF	in Access
Int	Numeric(10,0)	Long Integer
Bigint	Numeric(19,0)	Long Integer
Decimal	Numeric(p,s)	Decimal
Float	Float	Double
Text	Character(n)	Text(n)
Long text	Memo	Long Text
Date	Date	Date/Time
Datetime	(none)	Date/Time
Binary	(none)	OLE Object
Boolean	Logical	Yes/No
JSON	(none)	Long Text

Dialect differences

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

Property	in DBF	in Access
identifiers	—	[square brackets]
row limit	(driver dependent)	SELECT TOP n
dates	Date (D)	Date/Time
long text	Memo (M)	MEMO
binary	—	OLE Object

No counterpart

• Access has no equivalent for Date and time - it has to be flattened or dropped.
• Access has no equivalent for Binary - it has to be flattened or dropped.
• Access has no equivalent for JSON - it has to be flattened or dropped.

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.