>Is there a way to do this with office automation? I want to do this programmatically. TIA

Mathew,

If you're not already comfortable with the Excel object model, I would first recommend taking a look at that to get an idea of how to do the tasks you need to accomplish (here's a place to start: http://tinyurl.com/2dl4o).

I don't know how your Excel data is laid out, but certainly you could iterate through each spreadsheet row for the data you need and either insert the values into a VFP table or open up a connection to SQL Server and insert them into a table on that database. That is exactly how I import data into our application.

Laterness,
Jon