Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Import Excel spreadsheet into VFP using my VFP program?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00705123
Message ID:
00705130
Views:
18
Hi!

Take a look to APPEND FROM command in the help - it allows importing of data from different formats. You can also use ADO to open Excel file and work with data through ADO, or convert ADO recordset into VFP cursor.

HTH.

>Currently I use Excel to export a spreadsheet to VFP DBF format that VFP can read. Then I read the imported VFP DBF file using a front-end program that I wrote which rewrites the records into a better field structure for reporting purposes.
>
>My question is
>Is there a command or set of commands that I can put in my front-end program that will do the Excel spreadsheet to VFP BDF file conversion automatically and save me that step or will the export from Excel to VFP always be a manual process?
>
>Thanks for the help.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.com
ICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs

It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.
Previous
Reply
Map
View

Click here to load this message in the networking platform