Access Database Export - Fixed Width Specs Fields change after exporting, also will not let me save a new Specs

Question

Hi There, I am a newer user to Access. I have been trained enough to upload an excel file and then export it to a text file using the Fixed Width format where the specs were preset by the previous admin in my position. However, I have recently ran into an issue where after I export one file it completely changes the Field Information. With that, I am also trying to create a brand new export specifics and it will let me create it and save it. But as soon as I close Access and try to use that export spec the Field Information parameters change like it does with my pre-made one. Any helps or guidance is very greatly appreciated! Please ask questions as I am not sure if I even gave enough info to explain the problem. I tried to upload some screen shots to help but I am not sure if those works. Cheers,

Answer 1

Do you process this file manually, or by using a Function or sub in VBA?

Answer 2

Hi Waqas,

Any updates as to why my export tables do not save or add decimals?

Thank you kindly,

Lisa

Answer 3

Hi Waqas, thank you so much for your time and attention to this. I did not see that I received a reply from you until now. The version i am running is:

Microsoft® Access® for Microsoft 365 MSO (Version 2312 Build 16.0.17126.20132) 64-bit

Please let me know if you have any other questions or need more info. I will bookmark this page so I don't miss it again.

Cheers,

Lisa

Answer 4

Dear respected Lisa Hume,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

I’m sorry you’re having a problem and for the situation you encountered, we deeply understand the inconvenience caused and apologize for it.

As per your description, it seems you're encountering a problem with the fixed width specifications in Microsoft Access when exporting data to a text file.

To confirm whether this is a bug in a specific version, please provide us the version information. To check version: Open Access>File>Account>Product Information and capture a full screenshot and share here (Please mask your private message for protecting your private message) and we will be tested on that version and verify the result with you.

Appreciate your patience and understanding and thank you for your time and cooperation.

Sincerely,

Waqas Muhammad