software

In the original data file (text file - csv format) one of the fields has date
data and it looks like this: Jan-06. When I select quot;text to columnsquot; and
parse the data, the format of this field changes and looks like this: 6-Jan.
I need to import this data into access and this date field is causing
problems. I tried manually changing the format back to its original form but
when I save the file and then go back into it, it shows up as 6-Jan again.
How do I keep the formatting from changing when I parse the data? Thanks.
Any help is appreciated.
--
Terri

Try:

Format gt; Cells... gt; Number gt; Custom and use mmm-yy
--
Gary's Studentquot;terriquot; wrote:

gt; In the original data file (text file - csv format) one of the fields has date
gt; data and it looks like this: Jan-06. When I select quot;text to columnsquot; and
gt; parse the data, the format of this field changes and looks like this: 6-Jan.
gt; I need to import this data into access and this date field is causing
gt; problems. I tried manually changing the format back to its original form but
gt; when I save the file and then go back into it, it shows up as 6-Jan again.
gt; How do I keep the formatting from changing when I parse the data? Thanks.
gt; Any help is appreciated.
gt; --
gt; Terri

When you do the TextToColumns, format that column as TEXT instead of general.

Vaya con Dios,
Chuck, CABGx3
quot;terriquot; wrote:

gt; In the original data file (text file - csv format) one of the fields has date
gt; data and it looks like this: Jan-06. When I select quot;text to columnsquot; and
gt; parse the data, the format of this field changes and looks like this: 6-Jan.
gt; I need to import this data into access and this date field is causing
gt; problems. I tried manually changing the format back to its original form but
gt; when I save the file and then go back into it, it shows up as 6-Jan again.
gt; How do I keep the formatting from changing when I parse the data? Thanks.
gt; Any help is appreciated.
gt; --
gt; Terri


quot;terriquot; gt; wrote in message
...
gt; In the original data file (text file - csv format) one of the fields has
gt; date
gt; data and it looks like this: Jan-06. When I select quot;text to columnsquot;
gt; and
gt; parse the data, the format of this field changes and looks like this:
gt; 6-Jan.
gt; I need to import this data into access and this date field is causing
gt; problems. I tried manually changing the format back to its original form
gt; but
gt; when I save the file and then go back into it, it shows up as 6-Jan again.
gt; How do I keep the formatting from changing when I parse the data? Thanks.
gt; Any help is appreciated.
gt; --
gt; Terri

Format the cells in the Excel sheet *before* they receive the text data.
Then, copy amp; paste the data into those cells.
I did try that before and it works if I save the file as an excel file. I
was trying to keep the document as a text file (csv format) before I load
into Access to keep from having to do that extra step. I should have
mentioned that in the question. Thanks anyway. It seems like we will just
have to take the extra step. Thanks.
--
Terriquot;Gary''s Studentquot; wrote:

gt; Try:
gt;
gt; Format gt; Cells... gt; Number gt; Custom and use mmm-yy
gt; --
gt; Gary's Student
gt;
gt;
gt; quot;terriquot; wrote:
gt;
gt; gt; In the original data file (text file - csv format) one of the fields has date
gt; gt; data and it looks like this: Jan-06. When I select quot;text to columnsquot; and
gt; gt; parse the data, the format of this field changes and looks like this: 6-Jan.
gt; gt; I need to import this data into access and this date field is causing
gt; gt; problems. I tried manually changing the format back to its original form but
gt; gt; when I save the file and then go back into it, it shows up as 6-Jan again.
gt; gt; How do I keep the formatting from changing when I parse the data? Thanks.
gt; gt; Any help is appreciated.
gt; gt; --
gt; gt; Terri

Thanks. I did what you advised but now I am having problems opening up the
saved csv file. I guess my computer has decided not to work any more today.
I will try opening it up on Monday and see if the formatting remained the
same.
--
Terriquot;CLRquot; wrote:

gt; When you do the TextToColumns, format that column as TEXT instead of general.
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;terriquot; wrote:
gt;
gt; gt; In the original data file (text file - csv format) one of the fields has date
gt; gt; data and it looks like this: Jan-06. When I select quot;text to columnsquot; and
gt; gt; parse the data, the format of this field changes and looks like this: 6-Jan.
gt; gt; I need to import this data into access and this date field is causing
gt; gt; problems. I tried manually changing the format back to its original form but
gt; gt; when I save the file and then go back into it, it shows up as 6-Jan again.
gt; gt; How do I keep the formatting from changing when I parse the data? Thanks.
gt; gt; Any help is appreciated.
gt; gt; --
gt; gt; Terri

If you're doing a lot of work with text files, go to www.download.com and
get yourself a copy of the free version of Notetab. Not quot;notepadquot;, but
Notetab. Handles huge text files nicely. Great for when you want to inspect
them before Excel has fiddled with them.

quot;terriquot; gt; wrote in message
...
gt; Thanks. I did what you advised but now I am having problems opening up
gt; the
gt; saved csv file. I guess my computer has decided not to work any more
gt; today.
gt; I will try opening it up on Monday and see if the formatting remained the
gt; same.
gt; --
gt; Terri
gt;
gt;
gt; quot;CLRquot; wrote:
gt;
gt;gt; When you do the TextToColumns, format that column as TEXT instead of
gt;gt; general.
gt;gt;
gt;gt; Vaya con Dios,
gt;gt; Chuck, CABGx3
gt;gt;
gt;gt;
gt;gt;
gt;gt; quot;terriquot; wrote:
gt;gt;
gt;gt; gt; In the original data file (text file - csv format) one of the fields
gt;gt; gt; has date
gt;gt; gt; data and it looks like this: Jan-06. When I select quot;text to columnsquot;
gt;gt; gt; and
gt;gt; gt; parse the data, the format of this field changes and looks like this:
gt;gt; gt; 6-Jan.
gt;gt; gt; I need to import this data into access and this date field is causing
gt;gt; gt; problems. I tried manually changing the format back to its original
gt;gt; gt; form but
gt;gt; gt; when I save the file and then go back into it, it shows up as 6-Jan
gt;gt; gt; again.
gt;gt; gt; How do I keep the formatting from changing when I parse the data?
gt;gt; gt; Thanks.
gt;gt; gt; Any help is appreciated.
gt;gt; gt; --
gt;gt; gt; Terri
By way of information, if you make certain kinds of formatting changes to a
csv file, and then close it, Excel will usually tell you that certain styles
can't be saved in a csv file. That's your hint, and the reason why you have
to have the Excel file as an intermediate step. Out of curiosity, though,
why are you sending the file through Excel before putting the data in
Access?

quot;terriquot; gt; wrote in message
...
gt;I did try that before and it works if I save the file as an excel file. I
gt; was trying to keep the document as a text file (csv format) before I load
gt; into Access to keep from having to do that extra step. I should have
gt; mentioned that in the question. Thanks anyway. It seems like we will
gt; just
gt; have to take the extra step. Thanks.
gt; --
gt; Terri
gt;
gt;
gt; quot;Gary''s Studentquot; wrote:
gt;
gt;gt; Try:
gt;gt;
gt;gt; Format gt; Cells... gt; Number gt; Custom and use mmm-yy
gt;gt; --
gt;gt; Gary's Student
gt;gt;
gt;gt;
gt;gt; quot;terriquot; wrote:
gt;gt;
gt;gt; gt; In the original data file (text file - csv format) one of the fields
gt;gt; gt; has date
gt;gt; gt; data and it looks like this: Jan-06. When I select quot;text to columnsquot;
gt;gt; gt; and
gt;gt; gt; parse the data, the format of this field changes and looks like this:
gt;gt; gt; 6-Jan.
gt;gt; gt; I need to import this data into access and this date field is causing
gt;gt; gt; problems. I tried manually changing the format back to its original
gt;gt; gt; form but
gt;gt; gt; when I save the file and then go back into it, it shows up as 6-Jan
gt;gt; gt; again.
gt;gt; gt; How do I keep the formatting from changing when I parse the data?
gt;gt; gt; Thanks.
gt;gt; gt; Any help is appreciated.
gt;gt; gt; --
gt;gt; gt; Terri
My concern is that our data may be too big for excel so I need to keep it in
a text file to load into Access. Any other words of wisdom? Thanks.
--
Terriquot;Doug Kanterquot; wrote:

gt;
gt; quot;terriquot; gt; wrote in message
gt; ...
gt; gt; In the original data file (text file - csv format) one of the fields has
gt; gt; date
gt; gt; data and it looks like this: Jan-06. When I select quot;text to columnsquot;
gt; gt; and
gt; gt; parse the data, the format of this field changes and looks like this:
gt; gt; 6-Jan.
gt; gt; I need to import this data into access and this date field is causing
gt; gt; problems. I tried manually changing the format back to its original form
gt; gt; but
gt; gt; when I save the file and then go back into it, it shows up as 6-Jan again.
gt; gt; How do I keep the formatting from changing when I parse the data? Thanks.
gt; gt; Any help is appreciated.
gt; gt; --
gt; gt; Terri
gt;
gt; Format the cells in the Excel sheet *before* they receive the text data.
gt; Then, copy amp; paste the data into those cells.
gt;
gt;
gt;

Excel has a limit of 65536 rows. Opening your text file in an text editor
and hitting CTRL-END will tell you how many lines you have. Again, my
question: Why are you opening the text file in Excel if its final
destination is Access?

quot;terriquot; gt; wrote in message
...
gt; My concern is that our data may be too big for excel so I need to keep it
gt; in
gt; a text file to load into Access. Any other words of wisdom? Thanks.
gt; --
gt; Terri
gt;
gt;
gt; quot;Doug Kanterquot; wrote:
gt;
gt;gt;
gt;gt; quot;terriquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; In the original data file (text file - csv format) one of the fields
gt;gt; gt; has
gt;gt; gt; date
gt;gt; gt; data and it looks like this: Jan-06. When I select quot;text to columnsquot;
gt;gt; gt; and
gt;gt; gt; parse the data, the format of this field changes and looks like this:
gt;gt; gt; 6-Jan.
gt;gt; gt; I need to import this data into access and this date field is causing
gt;gt; gt; problems. I tried manually changing the format back to its original
gt;gt; gt; form
gt;gt; gt; but
gt;gt; gt; when I save the file and then go back into it, it shows up as 6-Jan
gt;gt; gt; again.
gt;gt; gt; How do I keep the formatting from changing when I parse the data?
gt;gt; gt; Thanks.
gt;gt; gt; Any help is appreciated.
gt;gt; gt; --
gt;gt; gt; Terri
gt;gt;
gt;gt; Format the cells in the Excel sheet *before* they receive the text data.
gt;gt; Then, copy amp; paste the data into those cells.
gt;gt;
gt;gt;
gt;gt;