Rendering .dat saved customer data to a database

[mcollette]

I have a CD with files that were migrated from a Vax server and saved as .dat and would like to format the information in a database.

 

[SkipVought]

Hi,

What database application? (Oracle, SQL Server, Access, DB2)

What is the structure of the .dat file? (Text, numeric, date, etc.; fixed length or delimited)

Are there headings in the .dat?

Do you have an existing table(s) in your db, to append this data to?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[mcollette]

I would like to render it in an access databae; although the current customer data is in a program on the as/400. The data structure is mixed meaning, customer data; Test -names addresses; numeric - $amounts and delimited. There are headings;

 

[SkipVought]

Why not simply IMPORT? Save the import spec, so that you can reuse if necessary.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[mcollette]

Hi Skip;

I tried importing the data; which is zipped and it is taking a toll on my disk space and did not extract.

thanks

 

[SkipVought]

I tried importing the data; which is zipped and it is taking a toll on my disk space and did not extract.

Let's clarify.

Did the EXTRACT of the .dat file fail or did the IMPORT of the .dat file fail?

I would think that you must unzip prior to importing.

Can't help you will lack of disk space. Can you not extract to a network share?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[mcollette]

The file was unzipped and started the import again; of course the records came over in Access jumbled with the usual characters mixed but the table has a an error saying Unparsable Record; please help...

 

[SkipVought]

The data structure is mixed meaning, customer data; Test -names addresses; numeric - $amounts and delimited.

How are they delimited?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[mcollette]

I tried tab and comma; because it is customer date; i.e. in columns - Cust Id Loc Id Account # Account Amount Street Address; etc

 

[SkipVought]

I tried tab and comma...

This is not a guessing game!!!

You must know without any uncertainty, exactly what the delimiter character is.

THAT SPECIFIC DELIMITER CHARACTER is what you must use to parse you data in the IMPORT process!!!

Is this not a know piece of information?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[SkipVought]

How about you COPY the headings and several lines of detail, and PASTE here. WE may get a hint.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[mcollette]

This is information that I have never seen before that was removed from an old unsupported server, but the need now exists for users to view the data;

ACC0  34290
ACC00340034290  
 > > ¡ ~  This is what the data looks like in Access
I will see if someone else has more knowledge; don't want to take up too much of your time; as you can imagine, I am not a programmer. Thank you for your patience.

 

[SkipVought]

You need to copy the headings and several lines of data, from the SOURCE .data file, NOT from Access.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[mcollette]

I am unable to open the source .DAT file; I have been trying to open it using different file extensions without success; this is as close to reading it using word or notepad.

 

[SkipVought]

Somehow, you need to determine the delimiter, so that you can properly parse the IMPORT.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[SkipVought]

Here's what the string your posted looks like with ASCII values
[tt]
03066643333035555401330666445544555540033333333003063631333130
52157782222521207846221577881288120784822222222412222221222626

ACC0  34290
ACC00340034290 
> > ¡ ~ 
[/tt]


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]