I need to import dates from a linked table then export them out as text to
an Excel spreadsheet. The problem is the dates need to be in ascending
order when I dump them out to Excel - and there's no telling what order they
are in in the linked table.

I've tried this:

INSERT INTO tblExcelData
SELECT [MeasurementId] AS TestID, [MeasurementDate] AS MeasDate,
[MeasurementTime] AS MeasTime
FROM Measurement
ORDER BY [MeasurementDate], [MeasurementTime];

But the dates don't appear in ascending order in tblExcelData.

When I dump them out to Excel, I'll need to concatenate:

MeasDate + " " + MeasTime (this is the text string goes to Excel - needs to
be text...)

So I need some way to sort the table while the data is in date format before
running another query to export as text into Excel.

What's the best way to sort the data in the table? Do I need an index?

Thanks in advance.

In your table 'Measurement' are the fields MeasurementDate and MeasurementTime date/time-fields or text?
You will need date/time fields to sort on.
[color=blue]
> What's the best way to sort the data in the table? Do I need an index?[/color]
When you use an autonumber as index, when your insert-query-records are in the right order, you will be allright.
Is there an index (maybe TestID) in your tblExcelData now?

Arno R

"deko" <deko@deko.com> schreef in bericht news:mG_7e.2826$t85.1262@newssvr21.news.prodigy.co m...[color=blue]
>I need to import dates from a linked table then export them out as text to
> an Excel spreadsheet. The problem is the dates need to be in ascending
> order when I dump them out to Excel - and there's no telling what order they
> are in in the linked table.
>
> I've tried this:
>
> INSERT INTO tblExcelData
> SELECT [MeasurementId] AS TestID, [MeasurementDate] AS MeasDate,
> [MeasurementTime] AS MeasTime
> FROM Measurement
> ORDER BY [MeasurementDate], [MeasurementTime];
>
> But the dates don't appear in ascending order in tblExcelData.
>
> When I dump them out to Excel, I'll need to concatenate:
>
> MeasDate + " " + MeasTime (this is the text string goes to Excel - needs to
> be text...)
>
> So I need some way to sort the table while the data is in date format before
> running another query to export as text into Excel.
>
> What's the best way to sort the data in the table? Do I need an index?
>
> Thanks in advance.
>
>
>[/color]