×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Rendering .dat saved customer data to a database

Rendering .dat saved customer data to a database

Rendering .dat saved customer data to a database

(OP)
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.

RE: Rendering .dat saved customer data to a database



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,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

RE: Rendering .dat saved customer data to a database

(OP)
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;  

RE: Rendering .dat saved customer data to a database





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

Skip,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

RE: Rendering .dat saved customer data to a database

(OP)
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  

RE: Rendering .dat saved customer data to a database



Quote:

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,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

RE: Rendering .dat saved customer data to a database

(OP)
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...

RE: Rendering .dat saved customer data to a database


Quote:

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

Skip,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

RE: Rendering .dat saved customer data to a database

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

RE: Rendering .dat saved customer data to a database


Quote:

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,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

RE: Rendering .dat saved customer data to a database



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

Skip,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

RE: Rendering .dat saved customer data to a database

(OP)
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.

RE: Rendering .dat saved customer data to a database



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

Skip,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

RE: Rendering .dat saved customer data to a database

(OP)
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.

 

RE: Rendering .dat saved customer data to a database




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

Skip,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

RE: Rendering .dat saved customer data to a database




Here's what the string your posted looks like with ASCII values

03066643333035555401330666445544555540033333333003063631333130
52157782222521207846221577881288120784822222222412222221222626
 ACC0     34290  ACC00340034290         > > ¡   ~ 

 

Skip,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close