Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Query - SQL to Excel
Hi there
I am querying a SQL database. Up to now I have brought all records into Excel and manipulated the data from there. The date is an example as the date is a text field in dd-mm-yyyy format. I have used a formula to convert this into an Excel number type date. Is there a way to "convert" the date during the import process so that the selection could be based on a date range. Alternatively can a temporary field/ variable, outside the database, be used for this purpose somehow. As the database now exceeds Excel's maximum of 65536 rows, I am now desparate for a solution. Thanks in anticipation. Michael |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Can I use MS Query in Excel like an Append Query in Access | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |