Justincut
asked on
Formatting and aligning a text file into an Excel or Access file
Hi Guys, I recieve a Daily text file. Can someone show me how to export it to Excel or Access with the data columns in line? I enclose an attachment
GBO-Dashboard-Report.txt
GBO-Dashboard-Report.txt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
(all with different fields and datatypes.)
- N O N V A L I D A T E D T R A D E S / E V E N T S - [D E T A I L S]
- T R A D E S W I T H N O M T M
- C A S H F L O W S T A T U S
- R E Q U E S T S T A T U S
...etc
(There is also Header info for each of the "Tables")
Therefore there will be no simple way to import this one file (into Excel or Access) and create all the needed "tables"
What you need to do is go back to the creator of this textfile, and ask that you be given instead, one file for each 'table' (data structure)
From there it looks this the data is comma delimited and can be imported into Access or Excel fairly easily
JeffCoachman