Formating excel fields to access format fields

[thread]

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

 

[Guest]

Try design mode of linked table in access to see if you can change the data
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 same
ID - You'll also have to add the ID field to the table you are appending..

just some thoughts,

 

[thread]

Hi Donica,

can you expatiate please the meaning of unique number i didnt
understand it so much
can you show me examples as well?
Donica כתב: