can you expatiate please the meaning of unique number i didnt
understand it so much
can you show me examples as well?
> Try design mode of linked table in access to see if you can change the da=
> type to long integer.
> Otherwise just import the Excel table check data type in of newly imported
> table so field is long Integer. Just append that data set.
> If you are constatnly importing Excel data from a large sheet, create a
> unique number in Excel, so you can append records that do not have the sa=
> ID - You'll also have to add the ID field to the table you are appending..
> just some thoughts,
> "thread" wrote:
> > Hi all,
> > Is it possible to make any equivalency between the type format of
> > access to the type format of the excel
> > i face this problem when trying to append excel linked table
> > one type format that was the more problematic was to find the correct
> > type format in the excel to adinteger(3) that is accually long
> > integer,it was all the time giving the type format of double(5)
> > any comments for this matter and in global to the type format matter