Editing Excel

  • Thread starter Thread starter MRW
  • Start date Start date
M

MRW

I'm downloading an Excel file from another server, putting it in
bytes, and saving it on my server in order to pull off information
from it. The file itself is set up properly, so in theory, I should
be able to access it with SQL statements. However, the files first
two rows have the title of the file and the date/time it was
produced. I need to simply delete those two rows and then the file
will be usable via SQL.

Does anybody have any idea on how I can simply delete those first two
rows without having to purchase additional software?

Thanks for the help!
 
Couple of ways to do this, open the file using the files system object and
delete up until the line delimiter. Or you could automate excel on the
server to do the dirty work for you. Some experts don't like automating
excel on the server because it isn't supported by MS - ok mark :-)

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99
 
Back
Top