>Hello Hilmar,
>Could you please tell me is it possible to get the data from excel and put it in foxpro table.
>
>Because we recv lot of data in the form of excel so here we enter the data manually into foxpro database table.
>
>so can i automate it in the button when clicked it should get the data from excel and put it in foxpro table.
>
>
>Thank you very much.
If I remember correctly, IMPORT FROM doesn't respect the header row (with fieldnames), created by the equivalent EXPORT TO.
The best way seems to me to give the "Save As" command in Excel. Of course, this can be automated.
This is, supposing that the data is in form of a table. If the data is in some other, more complicated, format, you have to write a program to get one cell at a time - through Automation.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)