EDI export

  • Thread starter Thread starter Rick F
  • Start date Start date
R

Rick F

Is there a way to export a query or information out of
acces in an 811 format? That is to export data in a
single column.

Example:
Name - Name of Employee
Rate - Billing rate for craft
Craft - Craft name
Badge # - Employee Number
Hours - Amount of hours
ST - Can be ST(straight time) or OT(over time)

I have all this information gathered in a payroll system
that I have written. I just have no idea if this is even
possible.

Thanks for your help,
Rick
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You can export the query results to a text file.

1) Right-click the query in the db window & select Export from the pop
up menu. Follow the instructions on the export dialog box.

2) Use VBA & TransferText method to do the same thing.

OR

You can loop thru the query's data w/ a Recordset and write to a text
file, one line per field. This will have to be done in VBA.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQS4iGIechKqOuFEgEQIjCACdFSFwe5QFugRYLWAniKie7wSzaqoAoJYv
62T61h3xKiPVgpaJDzYQbv9Y
=ArTL
-----END PGP SIGNATURE-----
 
Maybe I am not understanding you correctly. I know how to
export a text file from a query or table. My problem is a
query or table is in rows AND columns. I need to export
all data to a single column.

Example:
John Doe works 10 hours on January 1, 2004. He worked in
3 areas. This is the output I need.

John Doe
January 1 2004
Area 1
3 hours
$10 per hour
John Doe
January 1 2004
Area 2
3 hours
$10 per hour
John Doe
January 1 2004
Area 3
4 hours
$10 per hour

It has to all be in a single column.
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I was mistaken in my first suggestion. It was, actually, my last
suggestion but I moved it to the top before posting. Must have gone off
on a tangent while thinking of possibilities.

To put each column in one line you'll have to use VBA & a recordset.
Loop thru the recordset & write each Field of the recordset to a text
file line.

Read up on Fields (DAO or ADO) in the Access VBA help file.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQS+LsYechKqOuFEgEQLyagCcDoIEF7Ktcy46GiJfFk9meaTr3uoAnAsn
sreidc9rgLIZ59sVC3cZZHGU
=lW1R
-----END PGP SIGNATURE-----
 
Back
Top