L
Larry
I am using Access XP and trying to export queries to Excel XP with
memo fields that are getting truncated to 255. These fields have some
functions in them to get them to look right, so the only way I can
think to get them exported to Excel properly is to create a temporary
table then export that table instead.
The problem is, some of the queries do not have data longer than 255
and some do. They also do not all have the same columns. So I cannot
create a standard table and export to that table. What I was trying to
do in my code (to make it work with multiple queries) is simply write
a SQL statement like this:
"SELECT * INTO TEMP_EXPORT FROM [" & strQueryName & "]"
This exports the data, but some of the columns that need to be Memo
fields are not created "automatically" as memos. Some of the queries
bring back several hundred rows and I guess Access is looking at the
first X percent and saying, "ok, that column can be a text field", but
then it truncates data that tends to be longer later in the query.
Is there a way to force the fields to be memo fields when they are
created this way?
Does anyone have any other suggestions?
TIA,
Larry
memo fields that are getting truncated to 255. These fields have some
functions in them to get them to look right, so the only way I can
think to get them exported to Excel properly is to create a temporary
table then export that table instead.
The problem is, some of the queries do not have data longer than 255
and some do. They also do not all have the same columns. So I cannot
create a standard table and export to that table. What I was trying to
do in my code (to make it work with multiple queries) is simply write
a SQL statement like this:
"SELECT * INTO TEMP_EXPORT FROM [" & strQueryName & "]"
This exports the data, but some of the columns that need to be Memo
fields are not created "automatically" as memos. Some of the queries
bring back several hundred rows and I guess Access is looking at the
first X percent and saying, "ok, that column can be a text field", but
then it truncates data that tends to be longer later in the query.
Is there a way to force the fields to be memo fields when they are
created this way?
Does anyone have any other suggestions?
TIA,
Larry