I am a novice MSAccess user trying to import a .tab file into Access.
The problem I am having is that the import is completing far too early
with what I know are too few records in the resulting table.
I think the problem might be a result of an old garbage character (the
.tab file is of old data) that might be inducing a ctrl break before
the import finishes.
Anyone know how to filter out data during an import? I know that I can
skip fields but beyond that my options seem quite limited.
Advance thanks for the help gurus...
Tom van Stiphout - 04 Feb 2006 22:30 GMT
Sometimes you can get lucky importing the file in Excel first.
Otherwise you'll have to write some code to process the file yourself.
-Tom.
>I am a novice MSAccess user trying to import a .tab file into Access.
>The problem I am having is that the import is completing far too early
[quoted text clipped - 6 lines]
>
>Advance thanks for the help gurus...