S
Sean Davidson
This select statement worked fine in Access 2003:
SELECT * INTO data
FROM (Text;DATABASE=D:\Documents and Settings\sean\My
Documents\PWPIE\Reports\ClickThroughs\ArtSchools
[data#txt];
But now, even though Access 2007 will execute the query, I can't change it.
If I try to change the path or filename a little (for a different file),
heck - even if I add and remove a space, AC07 tells me there is a syntax
error at the "Text;" token of the from clause. How do I get around this?
SELECT * INTO data
FROM (Text;DATABASE=D:\Documents and Settings\sean\My
Documents\PWPIE\Reports\ClickThroughs\ArtSchools
[data#txt];But now, even though Access 2007 will execute the query, I can't change it.
If I try to change the path or filename a little (for a different file),
heck - even if I add and remove a space, AC07 tells me there is a syntax
error at the "Text;" token of the from clause. How do I get around this?