Using Report function to Export a text file to Enterprise Sys(exact Character limit) (1 Viewer)

[Dylan Snyder]

I have a fairly unique problem, I need to create an extract from Access to update an enterprise system. The format must be text, similar to the following format:

10ASTAR LOGISTICS TOM LEE
111.866.9876543


Where this would be one record. "10" is a field, "A" is a field, "Star Logistics" is a field...

I'm thinking I could just create a report and extract to a text file.

The problem is that there is a certain number of character/Spaces that the fields must be. The field for "Star Logistics", for example, must be exactly 30 Characters(including Spaces). Then the Contact name must be exactly 30 characters as well.

Is this possible in Access or am I in over my head?

 

[HiTechCoach]

I would use a query and export it in the format: "Fixed Width".

 

[Dylan Snyder]

Thanks- I need to structure the data so that one record would span multiple rows- not one record per row like a query would be set up. Is there a way to structure a query so that it would kook like:


record 1 field 1 record 1 field 2
record 1 field 3 record 1 field 4

record 2 field 1 record 2 field 2
record 2 field 3 record 2 field 4

 

[gemma-the-husky]

i think you would have to manually open a textfile, and write (print is the command) data into it formatted as you require.

you will need commands

freefile
open for output
print