We help IT Professionals succeed at work.

Import excel into FoxPro

omegabeta
omegabeta asked
on
Medium Priority
2,708 Views
Last Modified: 2010-10-05
I've tried  to import an execel file from FoxPro and the data fields are empty.
I've saved initialy in Excel the sheet as DBF file, but in FoxPro the data type columns from excel became character types

What can I do to avoid he problem ?

Thanks
Comment
Watch Question

Commented:
use the data import wizard in FoxPro


Dave

Author

Commented:
I've tried to do this but  even I've selected data type for some colums at the final process there are still character.
 
Founder, Software Engineer, Data Scientist
Commented:
Create cursor test (date D, string C(50), logical L, numeric N(20,2))

APPEND FROM myxlsfile.xls TYPE XLS FIELDS date, string, logical, numeric
Nirmal SharmaSolution Architect
Top Expert 2005

Commented:
Append from c:\myxlsfile.xls type xls fields date, string, logical, numeric.

Hey Cyril,

My syntax is written in "lower case" so please do not take it as duplicate post !........just kidding. :)

Hey omegabeta

What Cyril has told you is the one you're looking for?
CaptainCyrilFounder, Software Engineer, Data Scientist

Commented:
:-)

Author

Commented:

The file what I've get have had subtotals. The solution is to replace subtotals and then save as database(table).

The solution with "APPEND FROM myxlsfile.xls ..." worked partially because those fields with problems apears empty...

Thanks anyway.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.