how do i import data from excel, sort it then that information is.

J

jaxx

i need to import data from a table in an excel worksheet, sort it and filter
out the information i need before it enters that information into a different
worksheet. Ive tried using the external database but i think this only
enables me to import from an external sorce such as access. Does anyone have
any ideas how i can do this pls?
 
P

Peo Sjoblom

Database query allows import from Excel, double click Excel files* when
given the option
 
J

jaxx

The problem is when i try this i get the answer SYNTAX ERROR in FROM CLAUSE
- i dont know what this means
 
Top