managing external data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a db which i need to lookp up some financial information from an excel
file.

the major problem is that the Excel file is very large and i only want to
look at a small ammount of data (rows)

so could someine tell me how to import a table from excel and then delete it
after i have extracted the data i need?

thanks
 
Thankyou Eric,

have linked the spreedsheet now and have it working.

could you help me in opening a spreedsheet from a server loacation and
saving it to the local hard drive?


thanks.
 
I am not sure I understand. Do you want to copy a workbook from the server
to your c: drive or copy part of a workbook?
 
Here is some code

on error resume next
kill "destinationFile" ' delete file
FileCopy "sourcefile", "destinationFile"
 
Back
Top