Access Application not exporting after deleting field in table. 1

[coutoj]

Hello, We have a Microsoft Access Aplication that we give to customers to be able to enter in data and then export it to an informix database. My problem is we updated the table on the informix database and removed a field. So i tried to do the same thing in the access database table by removing the field, but when i try to export the table information to a flat file i get the following error:

Run-time error '3438':
The data being exported does not match the format described in the schema.ini file.

In the VBA i am running this code to export the information from the table to a flat file:

DoCmd.TransferText acExportDelim, &quot;<informix table name>&quot;, &quot;<title>&quot;, ExpPth.Value & &quot;\<destination file>&quot;

Thank you,

Jason Couto

 

[SuicidED]

Hi

Have you changed your export specification to reflect the deleted field, that could be the problem.

 

[coutoj]

Hello SuicidED, To change the export specs you mean i have to update the export_click code right. I didn't develop the application but here is the code from the export... maybe you can make heads or tails out of it.



Private Sub Export_Click()

Select Case TabCtl0.Value
.
.
.
Case 3
DoCmd.OpenForm &quot;Progress Window&quot;
Forms![Progress Window]![LabelTblNm].Caption = &quot;Product Test Standards&quot;
Forms![Progress Window].Repaint
Forms![Progress Window]![Box1].Visible = True
Forms![Progress Window]![Box2].Visible = True
Forms![Progress Window]![Box3].Visible = True
Forms![Progress Window]![Box4].Visible = True
Forms![Progress Window]![Box5].Visible = True
Forms![Progress Window].Repaint
DoCmd.TransferText acExportDelim, &quot;xinrtsd&quot;, &quot;Product Test Standards&quot;, ExpPth.Value & &quot;\inrtsd.txt&quot;
Forms![Progress Window]![Box6].Visible = True
Forms![Progress Window]![Box7].Visible = True
Forms![Progress Window]![Box8].Visible = True
Forms![Progress Window]![Box9].Visible = True
Forms![Progress Window]![Box10].Visible = True
Forms![Progress Window].Repaint
DoCmd.Close acForm, &quot;Progress Window&quot;



Thank you,

Jason Couto

 

[SuicidED]

Hi
Make sure you've backed the database up for safety.

DoCmd.TransferText acExportDelim, &quot;xinrtsd&quot;, &quot;Product Test Standards&quot;, ExpPth.Value & &quot;\inrtsd.txt&quot;

This contains the specification name &quot;xinrtsd&quot; which I believe you need to alter. The only way I can think of getting to it is to do File, Get External data, Import,point at a text file, then click on advanced and you should a box called Import specs. Click on the Specs button
and hopefully you shoud see &quot;xinrtsd&quot; . Open this and it will have the defined layout for your export. Remove the offending field and then save as some other name. (Just in case it goes wrong). Alter the above &quot;xinrtsd&quot; to the new name, and then click your button. This hopefully will fix it.

If anyone knows how to edit the specs easier, I'd loved to know.

Regards Eddie

 

[coutoj]

Hey SuicidED,

That did the trick... how did you know about this???

Thanks again for your amazing help...

Jason

Thank you,

Jason Couto

 

[SuicidED]

I've messed things up myself by altering fields, trial & error.
Glad it worked all the best Eddie