|
how to export data into query
how do you export dates into a query
|
how to export data into query
Excel dates are stored as numbers from a reference point,
either you need to adjust the number by subtracting (or adding) a constant; otherwise, if it is looking for a text date with slashes or hyphens then you would have to format another cell as text =TEXT(cellwithdate, "yyyy-mm-dd") in VBA code it would be something like strDate = FORMAT(datevariable,"yyyy-mm-dd") strDate = Format(Date, "yyyy-mm-dd") --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "tires85" wrote ... how do you export dates into a query |
how to export data into query
Thanks very much,
I will try this. "David McRitchie" wrote: Excel dates are stored as numbers from a reference point, either you need to adjust the number by subtracting (or adding) a constant; otherwise, if it is looking for a text date with slashes or hyphens then you would have to format another cell as text =TEXT(cellwithdate, "yyyy-mm-dd") in VBA code it would be something like strDate = FORMAT(datevariable,"yyyy-mm-dd") strDate = Format(Date, "yyyy-mm-dd") --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "tires85" wrote ... how do you export dates into a query |
| All times are GMT +1. The time now is 02:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com