>If Excel2002 or later:
>-Create a new text file
>-Rename file to something with a udl extension. ie: myDataLink.udl
>-Dblclick the file
>-Select first tab of dialog and select VFPOLEDB there, select your dbc in second tab
>-In excel from menu Data\External data\Import data
>(select files of type udl)
>-Point to your udl file
>-Tables would be listed. Select (it's direct table. If you want you can set to SQL and give and write SQL there).
>
>If earlier then the udl is missing from menu (learned in last few days). Create and run a macro then. ie:
>
>
>strCon = "OLEDB;Provider=VFPOLEDB;Data Source=c:\mypath\mydbc.dbc"
>strSQL = "select * from myTable"
>
>ActiveSheet.QueryTables.Add( _
> Connection:=strCon, _
> Destination:= range("A1"), _
> SQL := strSQL ).Refresh
>
>PS: You can save excel file as XML and play with contents using any editor (then next time you'd simply open edited version from excel).
>Cetin
Excelent! Thank you.
...Y soy feliz, bien feliz, asi lo grito;
Mira, que el mundo sepa, que se sepa:
Soy feliz....
...And I'm happy, quite happy, so do I yell it;
Look, so the world knows it, so be known:
I'm happy...
Ismael Rivera "Oye cosita linda"
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only