Hi All,
This is my first time of using the Access forums and I’m hoping someone can help.
I am accidentally responsible for an MS Access 2010 company database where Customer and Loans information (amongst other things) are stored.
We have a requirement to export of the data from the database into a fixed width text file – that can be ingested by a 3rd party system.
At a stretch this would normally be something I could support – but the file format specification isn’t quite straight forward (for someone with my very limited Access skills)
An example of the data is this:
(HAVE INCLUDED ATTACHMENT)
The strange bit is the export extract is in 2 sections so Line 1 (Starting X1) has Personal Information and a Second line (Starting X2) has the Loan information.
In the above e.g. I have removed spurious information
If it was a fixed width of 1 line for personal and one for Loan tagged on the end – I could see a way to export. But the way it goes on a 2nd line I cant get my head around exporting.
I had toyed with creating 2 tables and a single string column with all data; one with Personal and one with Loan and somehow UNION them end export as fixed width with 1 column. But I’m not sure how to get working or if right idea
Any advice would be greatly received
Kind regards
Dan