Is this a permanent conversion? If so, you can use the Import Wizard or APPEND FROM...XLS command.

SQL in Access? I didn't know this existed.



>We have thousands of excel spreadsheets of parts lists we want to convert into VFP.
>
>I need opinions on which is better to use, OLE Automation or ODBC.
>
>Also I need to know were I can find a reference for the
>Excel native SQL commands (for ODBC) needed to pass from VFP.
>Also I need a refernce for the Excel native commands for OLE Automation (similar to word.basic when using Word thru automation).
>
>I have searched MSDN (WWW and CD-ROM) and manuals in vain for these. I must be missing the proper terminlogy to properly search for them.