export from query to tab delimited text file

[xg]

i want to export to TAB delimited text file from query. the date field
always include time value even if I set date format to medium date format.

i want yyyy-mm-dd format so i can import into mysql database and it seems
mysql only likes this format.

 

[Guest]

I'm assuming that you have the Tab portion figure out. If not the big hint is
to use and import spec.

In your query, put something like below with the proper field name in
YourDateField.

DateYMD: Format([YourDateField], "yyyy-mm-dd"))

 

[xg]

Thank you for your quick reply. The format functon works. However, how to
convert date to string? I have many rows. some rows have date on that field,
some are blank. since mysql does not like blank in date field, i have to put
'0000-00-00' in the field. however, access does not allow me to put that
into date field.

I'm assuming that you have the Tab portion figure out. If not the big hint
is
to use and import spec.

In your query, put something like below with the proper field name in
YourDateField.

DateYMD: Format([YourDateField], "yyyy-mm-dd"))
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

i want to export to TAB delimited text file from query. the date field
always include time value even if I set date format to medium date
format.

i want yyyy-mm-dd format so i can import into mysql database and it seems
mysql only likes this format.

 

[John Spencer]

IIF(YourDateField Is Null, "0000-00-00", Format(YourDateField,"yyyy-mm-dd"))

Thank you for your quick reply. The format functon works. However, how to
convert date to string? I have many rows. some rows have date on that
field, some are blank. since mysql does not like blank in date field, i
have to put '0000-00-00' in the field. however, access does not allow me
to put that into date field.

I'm assuming that you have the Tab portion figure out. If not the big
hint is
to use and import spec.

In your query, put something like below with the proper field name in
YourDateField.

DateYMD: Format([YourDateField], "yyyy-mm-dd"))
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

i want to export to TAB delimited text file from query. the date field
always include time value even if I set date format to medium date
format.

i want yyyy-mm-dd format so i can import into mysql database and it
seems
mysql only likes this format.

 

[xg]

perfect! Thanks.

IIF(YourDateField Is Null, "0000-00-00",
Format(YourDateField,"yyyy-mm-dd"))

Thank you for your quick reply. The format functon works. However, how to
convert date to string? I have many rows. some rows have date on that
field, some are blank. since mysql does not like blank in date field, i
have to put '0000-00-00' in the field. however, access does not allow me
to put that into date field.

I'm assuming that you have the Tab portion figure out. If not the big
hint is
to use and import spec.

In your query, put something like below with the proper field name in
YourDateField.

DateYMD: Format([YourDateField], "yyyy-mm-dd"))
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


:

i want to export to TAB delimited text file from query. the date field
always include time value even if I set date format to medium date
format.

i want yyyy-mm-dd format so i can import into mysql database and it
seems
mysql only likes this format.