Excel Data to record set

[NewCoder2]

Is it possible to import excel data to a record set ? I saw this thread,

http://www.tek-tips.com/viewthread.cfm?SQID=799692&SPID=705&newpid=705&page=1

Which is similar, but not quite the same. I'd like to be able to pull in my excel data in to a rs. Any Ideas would be greatly appreciated. Thanks.

 

[lupins46]

Can you link to the Excel worksheet?
If so you can just open a recordset based on the linked 'table' name.

 

[NewCoder2]

linking isn't an option as I need to create the rs on the fly because this is part of a larger solution. Just a small mod in a rather large app.

thanks