Import Of data to table

[Lokesh]

hi i am having a problem with importing of data to the table.
First i had uploaded a sample list to the table and then assigned the data
type to all the fields. now when i upload a fresh list with the same data
type it throws error.
when i export the sample data and change the primary key and import it takes
it but not the fresh data.

 

[Wayne-I-M]

Hi you need to give more details of the problem.

eg.
If you have 2 tables with Autonumber fields as the primary then you need to
paste append (not just cut-n-paste)
etc

Can you give examples of any messages you are getting when you import - how
are you importing - etc etc

 

[Lokesh]

Hi you need to give more details of the problem.

eg.
If you have 2 tables with Autonumber fields as the primary then you need to
paste append (not just cut-n-paste)
etc

Can you give examples of any messages you are getting when you import - how
are you importing - etc etc

Hi
i am trying to import the data from excel to access table i am getting an
error - microsoft Access is not able to append the data

 

[Wayne-I-M]

It is most likely somthing simple - make a copy of you table 1st

Then - on the copy change the primary field to a number (if it is
anautonumber now) then try importing your stuff again.