Import multiple Excel sheets to a single Visual FoxPro table

by

Want to import data from multiple Excel sheets to a single Visual FoxPro table at a time?

Try Withdata FileToDB, a desktop Excel to Visual FoxPro converter for Windows, MacOS, and Linux, Convert Excel to Visual FoxPro, Easy and Fast.

Download Withdata FileToDB Download FileToDB

Import data from multiple Excel sheets to a single Visual FoxPro table

Login to Visual FoxPro -> Choose Excel file -> Set Visual FoxPro table -> Import multiple Excel sheets to Visual FoxPro

Choose Visual FoxPro and logon.

convert multiple Excel sheets to a single Visual FoxPro table - Choose Visual FoxPro and logon

Click “Wizard – 1 File To 1 Table” at task dialog.

convert multiple Excel sheets to a single Visual FoxPro table - task window

Select the “Excel” file type.

load multiple Excel sheets to a single Visual FoxPro table - select file type

then show the wizard.

1. Open Excel file, set “Sheet” to “All”.

convert multiple Excel sheets to a single Visual FoxPro table - Open Excel file

2. Select a Visual FoxPro table and config fields.

import multiple Excel sheets to a single Visual FoxPro table - select table

3. Preview data will be in Visual FoxPro table.

import multiple Excel sheets to a single Visual FoxPro table - preview

4. Import multiple Excel sheets to a single Visual FoxPro table.

import multiple Excel sheets to a single Visual FoxPro table - import data

View imported data in Visual FoxPro table

import multiple Excel sheets to a single Visual FoxPro table - view data


More about Excel to Visual FoxPro converter