LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 395
Default Best way to format a flat file that Excel will load properly?

I'm generating a flat file in Outlook VBA. Right now I'm able to save it as a
..txt file, although I hope to save it in a delimited flat file format with an
..xls extension so it will automatically be opened by excel without having to
go through the whole 'import' sequence.

There are string fields in the file, some of which contain commas- so I
can't make it a comma delimited file.

What is the best delimiter to use so that Excel will automatically recognize
and parse the flat file contents across columns?

Currently in 2003, but strongly prefer solutions that will also work in 2007

Many thanks,
Keith
 
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
How to load web page into Excel properly? Eric Excel Discussion (Misc queries) 2 August 16th 09 04:55 PM
YYY-MM-DD format is changing when convert data to Flat File Bobby Excel Programming 3 June 23rd 09 12:25 PM
convert matrix to flat file format Felix Excel Discussion (Misc queries) 1 November 29th 07 02:11 PM
Repeated data into flat file format Paul Simon Excel Worksheet Functions 4 July 9th 06 04:33 AM
How to convert a Pivot Table into a Flat File format? [email protected] Excel Discussion (Misc queries) 1 February 22nd 06 05:17 PM


All times are GMT +1. The time now is 04:25 AM.

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"