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
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 ×פר××, 05:55, Tom van Stiphout
> On Wed, 2 Apr 2008 15:15:38 -0700 (PDT), thread
> 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=
×=98-
Aha..., a new and this time *very* specific and clear question:=20
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 ...=20
but IMO the way some questions are asked is not funny at all...
Arno R
"thread"
news:00659397-80a3-483e-94c0-c94e235de761@s8g2000prg.googleg roups.com...
On 3 ×פר××, 05:55, Tom van Stiphout =
> On Wed, 2 Apr 2008 15:15:38 -0700 (PDT), thread
> 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-×סתר ××§×¡× =
×צ×××-
>
> -×ר×× ××§×¡× =
×צ×××-
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 ×פר××, 16:43, "Arno R"
> 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"
c0-c94e235de761@s8g2000prg.googlegroups.com...
> On 3 ×פר××, 05:55, Tom van Stiphout
> > 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=
¦×××=98-
>
> > -×ר×× ××§×¡× ×צ×=D7=
×=98--×סתר ××§×¡× ×צ=D7=
××=98-
>
> -×ר×× ××§×¡× ×צ×=D7=
×=98-
thread
news:b341c9ea-96cb-406b-9ff7-c434b7bcb5ad@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 ×פר××, 22:42, lyle fairfield
> thread
5ad@i36g2000prf.googlegroups.com:
>
> > it happends with every excel file you will try to link from the web
>
> Really?
> On 4 ?????, 22:42, lyle fairfield
> > > it happends with every excel file you will try to link from the web
>
> > Really?
"thread"
> 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 ×פר××, 04:48, "Larry Linson"
> Â > On 4 ?????, 22:42, lyle fairfield
>
> Â > > > it happends with every excel file you will try to link from th=
e web
> Â >
> Â > > Really?
>
> "thread"
>
> Â > is there a diffrent option?
>
> Is what you did an option? Â So far, it doesn't seem to work. Â Ha=
ve you
> carefully read the Help on Get External Data, and Link?
>
> Â Larry Linson