Import Of data to table

  • Thread starter Thread starter Lokesh
  • Start date Start date
L

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.
 
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
 
Wayne-I-M said:
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
Click to expand...

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
 
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.
 
Back
Top