Exporting to Text from a Query

[kime1974]

We have a query to export to text using fixed width. The query is using 3 tables and is 9,134 characters per record. It allows us to run the query, but when we try to export it we get the error "Record is too Large." Any thoughts on how we can get the data out of Access in the fixed width format from the tables? Thanks!!

 

[PWise]

What is the Sql of the Query and how are you exporting it

 

[kime1974]

Here is the SQL...I should not that this is for an insurance member conversion and it has to be in a fixed field lenghth format. If a field does not contain the fixed width, it must be filled with blanks at the end.

SELECT Conversion_Sub_KimTest.RecordType, Conversion_Sub_KimTest.SubRefID, Conversion_Sub_KimTest.SubCusRefType, Conversion_Sub_KimTest.DepRefID, Conversion_Sub_KimTest.DepCusRefType, Conversion_Sub_KimTest.CusPlan, Conversion_Sub_KimTest.CusProduct, Conversion_Sub_KimTest.MemberEffDate, Conversion_Sub_KimTest.Unused1, Conversion_Sub_KimTest.CusOrgLastName, Conversion_Sub_KimTest.CusOrgFirstName, Conversion_Sub_KimTest.CusOrgMiddleName, Conversion_Sub_KimTest.CusOrgDOB, Conversion_Sub_KimTest.CusOrgSex, Conversion_Sub_KimTest.GroupCusRefID, Conversion_Sub_KimTest.InsuredRelation, Conversion_Sub_KimTest.DOD, Conversion_Sub_KimTest.UpdateTimestamp, Conversion_Sub_KimTest.UpdateUserID, Conversion_Sub_KimTest.Unused2, Conversion_Sub_KimTest.CusServComments, Conversion_Sub_KimTest.CusContractType, Conversion_Sub_KimTest.CusRefID2, Conversion_Sub_KimTest.CusRefType2, Conversion_Sub_KimTest.CusRefUserID2, Conversion_Sub_KimTest.CusRefAdded2, Conversion_Sub_KimTest.CusRefID3, Conversion_Sub_KimTest.CusRefType3, Conversion_Sub_KimTest.CusRefUserID3, Conversion_Sub_KimTest.CusRefAdded3, Conversion_Sub_KimTest.CusRefID4, Conversion_Sub_KimTest.CusRefType4, Conversion_Sub_KimTest.CusRefUserID4, Conversion_Sub_KimTest.CusRefAdded4, Conversion_Sub_KimTest.CusRefSpace1, Conversion_Sub_KimTest.InsuredEventType1, Conversion_Sub_KimTest.InsuredEventReason1, Conversion_Sub_KimTest.InsuredEventDate1, Conversion_Sub_KimTest.InsuredEventType2, Conversion_Sub_KimTest.InsuredEventReason2, Conversion_Sub_KimTest.InsuredEventDate2, Conversion_Sub_KimTest.InsuredEventSpace1, Conversion_Sub_KimTest.InsuredEventSpace2, Conversion_Sub_KimTest.CustContractEventType1, Conversion_Sub_KimTest.CusContractEventDate1, Conversion_Sub_KimTest.CustContractEventType2, Conversion_Sub_KimTest.CusContractEventDate2, Conversion_Sub_KimTest.CusContractEventSpace, Conversion_Sub_KimTest.CusContractPPt1, Conversion_Sub_KimTest.CusContractPPt2, Conversion_Sub_KimTest.CusContractPPt3, Conversion_Sub_KimTest.CusContractPPt4, Conversion_Sub_KimTest.CusContractPPt5, Conversion_Sub_KimTest.CusContractPPt6, Conversion_Sub_KimTest.CusContractPPt7, Conversion_Sub_KimTest.CusContractPPt8, Conversion_Sub_KimTest.CusContractPPt9, Conversion_Sub_KimTest.CusContractPPt10, Conversion_sub_KimTest3.CusContractPPt11, Conversion_sub_KimTest3.CusContractPPt12, Conversion_sub_KimTest3.CusContractPPt13, Conversion_sub_KimTest3.CusContractPPt14, Conversion_sub_KimTest3.CusContractPPt15, Conversion_sub_KimTest3.CusContractPPt16, Conversion_sub_KimTest3.CusContractPPt17, Conversion_sub_KimTest3.CusContractPPt18, Conversion_sub_KimTest3.CusContractPPt19, Conversion_sub_KimTest3.CusContractPPt20, Conversion_sub_KimTest_Table2.PlanOrgEntityName, Conversion_sub_KimTest_Table2.PlanOrgEntityName2, Conversion_sub_KimTest_Table2.PlanOrgEntityName3, Conversion_sub_KimTest_Table2.PlanOrgEntityName4, Conversion_sub_KimTest_Table2.PlanOrgEntityName5, Conversion_sub_KimTest_Table2.PlanOrgEntityName6, Conversion_sub_KimTest_Table2.InsuredDateQual, Conversion_sub_KimTest_Table2.InsuredDateUserID, Conversion_sub_KimTest_Table2.InsuredDateAdded, Conversion_sub_KimTest_Table2.InsuredDateDeleted, Conversion_sub_KimTest_Table2.BlankSpace, Conversion_sub_KimTest_Table2.LocationCode, Conversion_sub_KimTest_Table2.CusAddrType1, Conversion_sub_KimTest_Table2.CusAddrDelivAddr1, Conversion_sub_KimTest_Table2.CusAddrBldg1, Conversion_sub_KimTest_Table2.CusAddrCity1, Conversion_sub_KimTest_Table2.CusAddrState1, Conversion_sub_KimTest_Table2.CusAddrZip1, Conversion_sub_KimTest_Table2.CusCountryCode1, Conversion_sub_KimTest_Table2.CusCountyCode1, Conversion_sub_KimTest_Table2.CusAddrType2, Conversion_sub_KimTest_Table2.CusAddrDelivAddr2, Conversion_sub_KimTest_Table2.CusAddrBldg2, Conversion_sub_KimTest_Table2.CusAddrCity2, Conversion_sub_KimTest_Table2.CusAddrState2, Conversion_sub_KimTest_Table2.CusAddrZip2, Conversion_sub_KimTest_Table2.CusCountryCode2, Conversion_sub_KimTest_Table2.CusCountyCode2, Conversion_sub_KimTest_Table2.CusAddressSpace1, Conversion_sub_KimTest_Table2.CusAddressSpace2, Conversion_sub_KimTest_Table2.EnrollmentType, Conversion_sub_KimTest_Table2.EnrollmentProvIDType, Conversion_sub_KimTest_Table2.EnrollmentProvID, Conversion_sub_KimTest_Table2.EnrollmentEff_ExpDate, Conversion_sub_KimTest_Table2.EnrollmentDeniedReason, Conversion_sub_KimTest_Table2.Field30_35A, Conversion_sub_KimTest_Table2.CusDOH, Conversion_sub_KimTest_Table2.CusMaritalStatus, Conversion_sub_KimTest_Table2.CusPositionEffDate, Conversion_sub_KimTest_Table2.CusPositionOcc, Conversion_sub_KimTest_Table2.CusPositionStatus, Conversion_sub_KimTest_Table2.CusPositionCategor, Conversion_sub_KimTest_Table2.CusPositionSubCategory, Conversion_sub_KimTest_Table2.CusPositionUnionPosition, Conversion_sub_KimTest_Table2.CusPositionUnionAffili, Conversion_sub_KimTest_Table2.SalaryBlank
FROM (Conversion_Sub_KimTest INNER JOIN Conversion_sub_KimTest_Table2 ON (Conversion_Sub_KimTest.SubRefID = Conversion_sub_KimTest_Table2.SubRefID) AND (Conversion_Sub_KimTest.DepRefID = Conversion_sub_KimTest_Table2.DepRefID) AND (Conversion_Sub_KimTest.GroupCusRefID = Conversion_sub_KimTest_Table2.GroupCusRefID)) INNER JOIN Conversion_sub_KimTest3 ON (Conversion_sub_KimTest_Table2.SubRefID = Conversion_sub_KimTest3.SubRefID) AND (Conversion_sub_KimTest_Table2.DepRefID = Conversion_sub_KimTest3.DepRefID) AND (Conversion_sub_KimTest_Table2.GroupCusRefID = Conversion_sub_KimTest3.GroupCusRefID)
ORDER BY Conversion_Sub_KimTest.SubRefID, Conversion_Sub_KimTest.DepRefID;

We are trying to export it by choosing export, then text and then fixed width. Thanks! kim