M
Michael Rekas
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
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