ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Saving Multiple Tables as CSV Data (https://www.excelbanter.com/excel-discussion-misc-queries/238281-saving-multiple-tables-csv-data.html)

Ken Valenti

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?


All times are GMT +1. The time now is 06:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com