Formating excel fields to access format fields

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

0
thread
5/9/2007 8:32:46 AM
access 16762 articles. 3 followers. Follow

1 Replies
858 Views

Similar Articles

[PageSpeed] 45

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 =D7=9B=D7=AA=D7=91:
> Try design mode of linked table in access to see if you can change the da=
ta
> 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=
me
> ID - You'll also have to add the ID field to the table you are appending..
>
> just some thoughts,
> --
> Regards,
>
> Donica
>
>
>
> "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
> >
> >

0
thread
5/9/2007 10:15:05 PM
Reply:

Similar Artilces: