Extracting from Excel and Access

Mark Powell Mark.Powell at veritas.com
Thu Jul 24 11:40:00 EDT 2003


Can anyone give me a pointer as to how to perform the following 2
pseudo-procedures

-1-
Open Excel file 'foo.xls'
Copy all the fields of sheet "blah" as text
put it into a var

-2-
Open Microsoft Access file 'foo.mdb'
Copy Table 'blah' as text
put it into a var

I am on Windows 2000 and I am not currently interested in querying the
contents of either.  I just want to extract and ruminate within Revolution.

Thanks in advance

Mark Powell



More information about the use-livecode mailing list