Unformatted Text File

[Cipher via AccessMonster.com]

I have several Text Files generated by another application. I am trying to
use Access but in the glorious tradition of Microsoft Access is fighting me
at every turn. Here is my problem:

1) I am loading the Text File into an Access Table
2) I have made a form to display this information
3) When I add or change this information in the Form, I want the data to
return back to the original Text File.
4) The data was NOT linked as Microsoft will not allow the data to be changed
(Running my life for me again)
5) When I try to alter the EXPORT parameters of the Form, I notice that the
FORMAT check box is checked and is also grayed-out so I cannot change it...
thanks again Microsoft.

This is what I want:
Read a Text File, Display the information in a Form, Change/add/delete
records in the Form back to the original Text File (without changing anything
except the data)...How can this be done please.

If using Access to accomplish this task is impossible, what database
application would be a better choice

 

[tina]

have you tried using a query to output the data as a text file? or using the
TransferText method in VBA directly on the table?

hth

 

[Cipher via AccessMonster.com]

Hi Tina:

All the information I need is in the Table, so I dont need a query. What I
want Access to do is:
1) Load data from a Text File
2) Allow me to add/delete data and save it back into the same text file
WITHOUT any format changes to the original Text File.

My question is...Is this posible with Access?

have you tried using a query to output the data as a text file? or using the
TransferText method in VBA directly on the table?

hth

I have several Text Files generated by another application. I am trying to
use Access but in the glorious tradition of Microsoft Access is fighting me

[quoted text clipped - 17 lines]

If using Access to accomplish this task is impossible, what database
application would be a better choice

 

[tina]

well, with TransferText, you could output the updated table data to a new
text file, overwriting the original file that has the obsolete data if you
choose to. as to whether you could get an identical format on the output,
you'd have to test it and see. other than that, you could probably write
code to open the text file, parse the data in some manner, and edit specific
portions of it. but i couldn't tell you how, sorry; for more information on
that as a possible solution, suggest you post to
microsoft.public.access.externaldata.

hth

Hi Tina:

All the information I need is in the Table, so I dont need a query. What I
want Access to do is:
1) Load data from a Text File
2) Allow me to add/delete data and save it back into the same text file
WITHOUT any format changes to the original Text File.

My question is...Is this posible with Access?

have you tried using a query to output the data as a text file? or using the
TransferText method in VBA directly on the table?

hth

I have several Text Files generated by another application. I am trying to
use Access but in the glorious tradition of Microsoft Access is

fighting me
[quoted text clipped - 17 lines]

If using Access to accomplish this task is impossible, what database
application would be a better choice

 

[Cipher via AccessMonster.com]

Hi Tina:

When I generate a table and form from the text file it all look good except
that Access saves the information from the Form into a different file and NOT
the original form. If I alter the data in the Table it saves the data back
into the original Text File as I want it too. It is the Form that screws up.

well, with TransferText, you could output the updated table data to a new
text file, overwriting the original file that has the obsolete data if you
choose to. as to whether you could get an identical format on the output,
you'd have to test it and see. other than that, you could probably write
code to open the text file, parse the data in some manner, and edit specific
portions of it. but i couldn't tell you how, sorry; for more information on
that as a possible solution, suggest you post to
microsoft.public.access.externaldata.

hth

Hi Tina:

[quoted text clipped - 16 lines]

 

[Cipher via AccessMonster.com]

How do I post to: microsoft.public.access.externaldata...where is it?

well, with TransferText, you could output the updated table data to a new
text file, overwriting the original file that has the obsolete data if you
choose to. as to whether you could get an identical format on the output,
you'd have to test it and see. other than that, you could probably write
code to open the text file, parse the data in some manner, and edit specific
portions of it. but i couldn't tell you how, sorry; for more information on
that as a possible solution, suggest you post to
microsoft.public.access.externaldata.

hth

Hi Tina:

[quoted text clipped - 16 lines]

 

[tina]

i think i'm not understanding your setup. i thought you were *importing* the
text data into a local Access table, since you said "The data was NOT linked
as Microsoft will not allow the data to be changed". and i don't understand
the statement "Access saves the information from the Form into a different
file and NOT the original form". i assumed that the form was bound to the
local table holding imported text data. is the form unbound, with code
running to save the entered data somewhere else? and, you can't save data
into a *form* at all, only into a table or an outside file, so i don't
understand that part of the statement at all. can you explain your setup in
more specific detail?

as for microsoft.public.access.externaldata, i'd guess you look in the same
place you found this ng. i use Outlook Express to subscribe to newsgroups,
and do all my interactions there, so that's where i found the
microsoft.public.access newsgroups. i can't really tell you how to find them
on the web, sorry; probably microsoft's website is a good place to start.

hth

Hi Tina:

When I generate a table and form from the text file it all look good except
that Access saves the information from the Form into a different file and NOT
the original form. If I alter the data in the Table it saves the data back
into the original Text File as I want it too. It is the Form that screws up.

well, with TransferText, you could output the updated table data to a new
text file, overwriting the original file that has the obsolete data if you
choose to. as to whether you could get an identical format on the output,
you'd have to test it and see. other than that, you could probably write
code to open the text file, parse the data in some manner, and edit specific
portions of it. but i couldn't tell you how, sorry; for more information on
that as a possible solution, suggest you post to
microsoft.public.access.externaldata.

hth

Hi Tina:

[quoted text clipped - 16 lines]

If using Access to accomplish this task is impossible, what database
application would be a better choice

 

[John W. Vinson]

How do I post to: microsoft.public.access.externaldata...where is it?

If you're using accessmonster as your only link to the newsgroups, it's there
that you should ask; try Importing/Linking on their main menu.

Note that accessmonster is only one of many ways to get to the newsgroups.