hi all
does anyone knows how to import/link a file that sits on a server
for now everytime im trying to import,im getting a message connect to
server but then it is cenceled
any ideas

On Wed, 2 Apr 2008 15:15:38 -0700 (PDT), thread <yaniv.dg [at] gmail.com>
wrote:

My idea is that you should rewrite your question and be a lot more
specific. Here is an article that can help with that:
http://www.mvps.org/access/netiquette.htm#Asking

-Tom.


>hi all
>does anyone knows how to import/link a file that sits on a server
>for now everytime im trying to import,im getting a message connect to
>server but then it is cenceled
>any ideas

On 3 =D7=90=D7=A4=D7=A8=D7=99=D7=9C, 05:55, Tom van Stiphout <no.spam.tom7..=
.. [at] cox.net> wrote:
> On Wed, 2 Apr 2008 15:15:38 -0700 (PDT), thread <yaniv... [at] gmail.com>
> wrote:
>
> My idea is that you should rewrite your question and be a lot more
hi its hard to explain it

i have some web system that i need to import to access(sort of a GDW)
there is a link that i can use but still i need to have additional
code probbly to add the password and user name

> specific. Here is an article that can help with that:http://www.mvps.org/a=
ccess/netiquette.htm#Asking
>
> -Tom.
>
>
>
> >hi all
> >does anyone knows how to import/link a file that sits on a server
> >for now everytime im trying to import,im getting a message connect to
> >server but then it is cenceled
> >any ideas-=D7=94=D7=A1=D7=AA=D7=A8 =D7=98=D7=A7=D7=A1=D7=98 =D7=9E=D7=A6=
=D7=95=D7=98=D7=98-
>
> -=D7=94=D7=A8=D7=90=D7=94 =D7=98=D7=A7=D7=A1=D7=98 =D7=9E=D7=A6=D7=95=D7=
=98=D7=98-

Aha..., a new and this time *very* specific and clear question:

So you need some code ??
Oh... and I see it is probbly to add the password and user name ...
Let me see....

Dim strPW as string, strUserName as string, strToAddProbbly as string
strPW=3D"helpmeplease"
strUserName=3D"thread"
strToAddProbbly=3DstrPW & ";" & strUserName

So now you have "helpmeplease;thread" in the strToAddProbbly

HTH ;-)

BTW: I am only trying to be funny here ...
but IMO the way some questions are asked is not funny at all...

Arno R


"thread" <yaniv.dg [at] gmail.com> schreef in bericht =
news:00659397-80a3-483e-94c0-c94e235de761 [at] s8g2000prg.googleg roups.com...
On 3 =D7=90=D7=A4=D7=A8=D7=99=D7=9C, 05:55, Tom van Stiphout =
<no.spam.tom7... [at] cox.net> wrote:
> On Wed, 2 Apr 2008 15:15:38 -0700 (PDT), thread <yaniv... [at] gmail.com>
> wrote:
>
> My idea is that you should rewrite your question and be a lot more
hi its hard to explain it

i have some web system that i need to import to access(sort of a GDW)
there is a link that i can use but still i need to have additional
code probbly to add the password and user name

> specific. Here is an article that can help with =
that:http://www.mvps.org/access/netiquette.htm#Asking
>
> -Tom.
>
>
>
> >hi all
> >does anyone knows how to import/link a file that sits on a server
> >for now everytime im trying to import,im getting a message connect to
> >server but then it is cenceled
> >any ideas-=D7=94=D7=A1=D7=AA=D7=A8 =D7=98=D7=A7=D7=A1=D7=98 =
=D7=9E=D7=A6=D7=95=D7=98=D7=98-
>
> -=D7=94=D7=A8=D7=90=D7=94 =D7=98=D7=A7=D7=A1=D7=98 =
=D7=9E=D7=A6=D7=95=D7=98=D7=98-

hey Arno i dont know who you are but by the way you are acting it
shows that your are ametuer
(i cannot reveal the system name but i will right instructions of what
i did and what i got)
it happends with every excel file you will try to link from the web
1)go to file->get extrnal data->link table
2)place the file full link
3)i'm getting a message while its been loading:"connecting to web
server"
4)i'm getting after 1 minute an error message:"not a valid file name"
any ideas here?

On 3 =D7=90=D7=A4=D7=A8=D7=99=D7=9C, 16:43, "Arno R" <arracomn_o_s_p_... [at] pla=
net.nl> wrote:
> Aha..., a new and this time *very* specific and clear question:
>
> So you need some code ??
> Oh... and I see it is probbly to add the password and user name ...
> Let me see....
>
> Dim strPW as string, strUserName as string, strToAddProbbly as string
> strPW=3D"helpmeplease"
> strUserName=3D"thread"
> strToAddProbbly=3DstrPW & ";" & strUserName
>
> So now you have "helpmeplease;thread" in the strToAddProbbly
>
> HTH =C2=A0 =C2=A0;-)
>
> BTW: I am only trying to be funny here ...
> but IMO the way some questions are asked is not funny at all...
>
> Arno R
>
> "thread" <yaniv... [at] gmail.com> schreef in berichtnews:00659397-80a3-483e-94=
c0-c94e235de761 [at] s8g2000prg.googlegroups.com...
> On 3 =D7=90=D7=A4=D7=A8=D7=99=D7=9C, 05:55, Tom van Stiphout <no.spam.tom7=
.... [at] cox.net> wrote:> On Wed, 2 Apr 2008 15:15:38 -0700 (PDT), thread <yaniv.=
... [at] gmail.com>
> > wrote:
>
> > My idea is that you should rewrite your question and be a lot more
>
> hi its hard to explain it
>
> i have some web system that i need to import to access(sort of a GDW)
> there is a link that i can use but still i need to have additional
> code probbly to add the password and user name
>
>
>
> > specific. Here is an article that can help with that:http://www.mvps.org=
/access/netiquette.htm#Asking
>
> > -Tom.
>
> > >hi all
> > >does anyone knows how to import/link a file that sits on a server
> > >for now everytime im trying to import,im getting a message connect to
> > >server but then it is cenceled
> > >any ideas-=D7=94=D7=A1=D7=AA=D7=A8 =D7=98=D7=A7=D7=A1=D7=98 =D7=9E=D7=
=A6=D7=95=D7=98=D7=98-
>
> > -=D7=94=D7=A8=D7=90=D7=94 =D7=98=D7=A7=D7=A1=D7=98 =D7=9E=D7=A6=D7=95=D7=
=98=D7=98--=D7=94=D7=A1=D7=AA=D7=A8 =D7=98=D7=A7=D7=A1=D7=98 =D7=9E=D7=A6=D7=
=95=D7=98=D7=98-
>
> -=D7=94=D7=A8=D7=90=D7=94 =D7=98=D7=A7=D7=A1=D7=98 =D7=9E=D7=A6=D7=95=D7=
=98=D7=98-

thread <yaniv.dg [at] gmail.com> wrote in
news:b341c9ea-96cb-406b-9ff7-c434b7bcb5ad [at] i36g2000prf.google groups.com:

> it happends with every excel file you will try to link from the web

Really?

is there a diffrent option?

On 4 =D7=90=D7=A4=D7=A8=D7=99=D7=9C, 22:42, lyle fairfield <lylef... [at] yah00.c=
a> wrote:
> thread <yaniv... [at] gmail.com> wrote innews:b341c9ea-96cb-406b-9ff7-c434b7bcb=
5ad [at] i36g2000prf.googlegroups.com:
>
> > it happends with every excel file you will try to link from the web
>
> Really?

> On 4 ?????, 22:42, lyle fairfield <lylef... [at] yah00.ca> wrote:

> > > it happends with every excel file you will try to link from the web
>
> > Really?

"thread" <yaniv.dg [at] gmail.com> wrote

> is there a diffrent option?

Is what you did an option? So far, it doesn't seem to work. Have you
carefully read the Help on Get External Data, and Link?

Larry Linson

this is what im doing and im trying to solve this problem
On 8 =D7=90=D7=A4=D7=A8=D7=99=D7=9C, 04:48, "Larry Linson" <boun... [at] localhos=
t.not> wrote:
> =C2=A0> On 4 ?????, 22:42, lyle fairfield <lylef... [at] yah00.ca> wrote:
>
> =C2=A0> > > it happends with every excel file you will try to link from th=
e web
> =C2=A0>
> =C2=A0> > Really?
>
> "thread" <yaniv... [at] gmail.com> wrote
>
> =C2=A0> is there a diffrent option?
>
> Is what you did an option? =C2=A0So far, it doesn't seem to work. =C2=A0Ha=
ve you
> carefully read the Help on Get External Data, and Link?
>
> =C2=A0Larry Linson