Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Convert CSVs to Excel workbook

Hi

We store our data in CSV files. Our new requirement is to send users
report in Excel format. Suppose we have 5 CSV files, we need to merge
these CSV files into an Excel workbook, with each csv and worksheets

My quesion is how to convert the CSV's to Excel workbook?

pls help

regards

Max
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,560
Default Convert CSVs to Excel workbook

Hi Max,
Open the file up in Excel you will be taken through a set of screens that
will walk you through the process. It is pretty straight forward, especially
if it is truely CSV file. Try it.

"Max" wrote:

Hi

We store our data in CSV files. Our new requirement is to send users
report in Excel format. Suppose we have 5 CSV files, we need to merge
these CSV files into an Excel workbook, with each csv and worksheets

My quesion is how to convert the CSV's to Excel workbook?

pls help

regards

Max

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Convert CSVs to Excel workbook

If the file has the extension .CSV, then Excel will just open the file. It
will not use the text import wizard.

--
Regards,
Tom Ogilvy

"David" wrote in message
...
Hi Max,
Open the file up in Excel you will be taken through a set of screens that
will walk you through the process. It is pretty straight forward,

especially
if it is truely CSV file. Try it.

"Max" wrote:

Hi

We store our data in CSV files. Our new requirement is to send users
report in Excel format. Suppose we have 5 CSV files, we need to merge
these CSV files into an Excel workbook, with each csv and worksheets

My quesion is how to convert the CSV's to Excel workbook?

pls help

regards

Max



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert Excel workbook in to .csv format Vicky Excel Discussion (Misc queries) 1 February 11th 09 04:50 AM
Excel 2003 will not open CSVs parsed out. Trolane Excel Discussion (Misc queries) 2 June 12th 08 10:31 PM
excel 2003 will not open CSVs parsed Trolane Excel Worksheet Functions 0 June 12th 08 03:13 PM
How do I set up an Excel workbook to convert GMT to EST? 49 forever Excel Worksheet Functions 4 February 14th 08 01:34 PM
how do I convert an Excel workbook to .txt or .csv ROSSPOSS Excel Discussion (Misc queries) 3 May 19th 05 06:56 PM


All times are GMT +1. The time now is 02:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"