Tiffany
I should have added: If the columns aren't in the same order as the table import into another table and then run an append query to get the records in the new table into the correct table. You'll just have to set up the append so each column goes to the right field.
Bill
--- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@...> wrote:
>
> Tiffany
>
> If I remember right, you have to have the excel columns in the same order as the table fields so Access knows where everything goes. Could that be the problem you are having?
>
> Bill
>
> --- In MS_Access_Professionals@yahoogroups.com, "cc0623" <cc0623@> wrote:
> >
> > I am trying to import data from excel and I keep getting the error "F1 does not exist in destination table", but it is in the table listed as Unit. Can anyone tell me hoe to fix this problem?
> >
> > Thanks,
> > Tiffany
> >
>
Tidak ada komentar:
Posting Komentar