asked on

MS Access Memo (Long Text) Field Not Exporting Correctly From a Query

I have a Query that gets exported daily to a CSV file automatically. I have a Long Text Descriptions Field in my SKUs Table. When it exports it Chops most of the text value off after around 255 characters.

I've read online that Access won't export Long Text correctly from a query and I have to export from a table instead.

Is this true?

Also if so how can I set this procedure up to do this Automatically?
Export Query to a new table.
Export new table to a CSV File.

The query looks good so it is happening after export.
I also read this info:
http://allenbrowne.com/ser-63.html

Thanks.

ASKER CERTIFIED SOLUTION

Hamed Nasr

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Dustin Stanley

ASKER

Did you export to a CSV File from a query?
I will have to see in the morning about a sample database. Thanks for the help!

Dustin Stanley

ASKER

By the way where I am it is 11:41PM and this link here seems to be what my issue is. I don't know exactly though.

https://support.microsoft.com/en-us/kb/208801

Hamed Nasr

Yes!
External Data > Export > Text > Query.csv > ... accepted all defaults

Dustin Stanley

ASKER

Ok thanks. I will see what I can do tomorrow

SOLUTION

Scott McDaniel (EE MVE )

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Jim Dettman (EE MVE)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Dustin Stanley

ASKER

Thank you for the help! I figured it out. When hnasr said he did it fine. It made me think well then something in the Automation of my export has to be wrong.

I tested it manually and it worked fine.

I then manually started the macro for the VBA automation of the export and it didn't work.

Here is where the problem was:

In the beginning of the database I had that description field set to short text 255 characters.

I then later found out it wasn't going to work as some descriptions are alot longer and I changed the Description field to a long Text (Memo).

Before I changed the Description field to Long Text I had made the Export "SPECIFICATIONS" and saved it.

So I deleted the saved "SPECIFICATION" from before the change and saved the exact same style of "SPECIFICATION" as a new name.

This refreshed the export "SPECIFICATION"

Then I changed the Specification Name in my VBA "DoCmd.TransferText"

Now all works perfect! THANKS!

Hamed Nasr

Welcome!

Scott McDaniel (EE MVE )

Thanks, but you really should not have included my comment in your Solution. I just asked a question, and I certainly don't need the points!

Dustin Stanley

ASKER

This forum is a very how should I say caring forum and I have always been told if someone comments then they should be included. As they tried and attempted to help.

Scott McDaniel (EE MVE )

You should really only accept comments that provide you with a solution, or assistance towards a solution. Not trying to browbeat you, of course - you can accept whatever comments you wish, but in general you should only accept the ones that helped you (and mine certainly did not).

Dustin Stanley

ASKER

I thank you Scott and I will keep this in mind.