R
Ray C
I have a linked table whereby I later execute a query like this:
SELECT * INTO MyLocalAccessTable FROM MyLinkedExcelTable
The strange thing is that sometimes when I look at my newly created table,
it isn't in the same order as the Excel worksheet it's linked to.
Any reasons why?
I need to keep it in the same order.
thanks
Ray
SELECT * INTO MyLocalAccessTable FROM MyLinkedExcelTable
The strange thing is that sometimes when I look at my newly created table,
it isn't in the same order as the Excel worksheet it's linked to.
Any reasons why?
I need to keep it in the same order.
thanks
Ray