Re: How do I import mainframe reports into an Access database?
- From: "G. Vaught" <glvaught@xxxxxxxxxxx>
- Date: Thu, 6 Jul 2006 21:34:08 -0600
If the data coming out of the mainframe is ASCII text and delimited with
comma's and quotes, then you can import the data to Access. If the format
out of the mainframe is different, check to see if it can be exported to
Excel first. Excel imports to Access quite easily if the data is defined
correctly. By this I mean, a text field is all text and is treated as text;
a numeric field is all numbers and no text is in the column.
"Joey" <Joey@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A60B172D-E04B-4FD0-BB5F-982F924D661E@xxxxxxxxxxxxxxxx
I'm using reports generated from mainframe accounting systems but am using
an
Access DB to generate reports. Currently the process of generating these
reports by other means has been labor intensive. I'm hoping that Access
will
allow me a greater ease of report production with tremendous time savings.
My manual and online Access help has returned no clear explanation.
Current process:
(1) Log into mainframe
(2) Collect data for report
(3) Save report query on the mainframe, C: drive, papercopy
(4) Manipulate data to compile report (*time consuming part)
What I would like to do is either import or link (if possible) these
mainframe reports into Access to more readily manipulate the data into
readible reports, quickly.
.
- Prev by Date: Re: Linked table Manager; how can I automate changing of the linked ta
- Next by Date: Re: Importing from Excel to an existing table / updating a table
- Previous by thread: Re: Linked table Manager; how can I automate changing of the linked ta
- Next by thread: Re: How do I import mainframe reports into an Access database?
- Index(es):
Relevant Pages
|
