The table does not have to be open For FREE Access ebook and videos click here http://access-databases.com/ebook
--- In [email protected], "Dick Root" <d1ckr...@...> wrote: > > I have succeeded in importing data into Access dozens of times. The > things I have looked out for was to make sure all the columns were > present in the file to be imported, and that the data typing was > correct i.e. putting letters in number columns, etc. Most of the time > the target table was empty. > The really important thing to remember is that the error messages are > not always correct. There are more kinds of errors than there are > error messages. When it can't figure out what to say it gets a bit random > > --- In [email protected], "cathybinva" <cbleakly@> wrote: > > > > Access 2003 - I am following the instructions in the Help function to > > import data to an existing table from an Excel spreadsheet. Everything > > goes great until I say "Finish". then I get a message that the table I > > want to import the data to is "already open" and it won't let me go any > > farther. Of course the table is open - it has to be open in order for > > me to invoke the Get External data function under the File tab. What > > am I doing wrong. > > I used to create Access applications many years ago but now everything > > is new and I'm having to learn a lot of stuff all over again. > > > > Thanks!!! > > >
