Data import

[Irina]

I have a question:
I have a folder with 3,700 .cse files, and i need to dump those somehow into
either a .txt file or excel to import those into Access db later.
The text of the files looks like this:
{A41F6C3E-2643-11D2-A02E-00A0FFFF9114}]
{1}
50=Philistin BYSSAINTHE^Arial@9@0@
120=500 Fernwood Avenue^Arial@9@0@
130=Rochester^Arial@9@0@
150=14609^Arial@9@0@
340=Philistin BYSSAINTHE^Arial@9@0@
180=Y,,
190=New York Court of Appeals^Arial@9@1@
330=All immigration matters regarding Philistin BYSSAINTHE.^@
30=^Arial@9@0@
40=^Arial@9@0@
80=N,
60=N,
90=N,
70=Y,
110=^Arial@9@0@
140=^Arial@9@0@
210=^Arial@9@0@
220=N,,
260=Harter Secrest & Emery LLP^Arial@9@1@
270=1600 Bausch & Lomb Place^Arial@9@1@
280=Rochester, New York 14604^Arial@9@1@
290=Margaret A. Catillaz, Esq.^Arial@9@1@
320=Margaret A. Catillaz, Esq.^Arial@9@0@
300=(716)231-1122^Arial@9@1@
310=(716)232-2152^Arial@8@1@
200=,,
240=,,
10=Form I-765 and Related Documents^Arial@9@1@<OVERRIDE>@
20=^Arial@9@1@
{2}
[{A41F6C41-2643-11D2-A02E-00A0FFFF9114}]
{1}
220=Y,,
240=,,
260=N,,
280=,,
360=Harter, Secrest & Emery LLP^Arial@9@1@
330=Margaret A. Catillaz, Esq.^Arial@9@1@<OVERRIDE>@
370=^@
340=^Arial@9@1@
{2}

So my question is, how do I dump those files into a readable format
for access automatically - if I do this manually, it would take me months....
is there some utility that would do such a thing?
please anyone advise

appreciate your expertise.

 

[Daniel Pineault]

Why not create a function in Access that would, 1 by 1, read the file and add
the info to the appropriate table fields?

You're going to need to explain your table structure vs. text file content
for us to be able to help design the function.

Might I also ask, why you are proposing going through a txt orExcel first?
The cse file can be open with a standard text editor? if so, then my original
solution stands.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com
If this post was helpful, please rate it by using the vote buttons.