>I have successfully created a routine whereby I can export data from a cursor into excel. I woule now like to use an excel file as an input file and populate a DBF. Can anybody point me in the right direction?
>
>Many Thanks
Neil,
More than one way.
-Import
-Append
-Automation
-SQL Pass Through
-CursorAdapter
-BindEvents,EventHandler
...
If you give names to ranges in Excel it'd be easier to manipulate it as blocks. All of these methods are not applicable under all cases (ie: SPT wouldn't work for all excel sheets).
Cetin