View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken Valenti Ken Valenti is offline
external usenet poster
 
Posts: 40
Default Saving Multiple Tables as CSV Data

I have several tables (Excel Spreadsheets) that I need to save the data as
quick as possible, over the LAN. So I programatically save every worksheet as
a CSV file to preserve the data.

I'm thinking of combining 3 tables into one CSV file, so that there is only
one "Save" over the LAN (instead of several).

If I skip rows, then can I import these as seperate tables & preserve the
formatting/data integrity - importing from one CSV file?