Database Import from FTP ?

[Guest]

I am attempting to import a 1 gig database from an ftp site and was trying to
figure out if the import should use ASCII or Binary methods? Or if there is
another method I should be using.

Thank you

 

[Douglas J Steele]

What exactly do you mean by importing from an ftp site? Are you hoping to
import tables from the database? If so, I'm afraid you're out of luck:
Access doesn't recognize the FTP protocol (nor the HTTP protocol, for that
matter).

On the other hand, if all you're trying to do is download the database,
since a MDB file is binary, not text, you'd need to use the Binary method.

 

[dbahooker]

Access _DOES_ recognize the HTTP protocol right?

i mean-- you can link to a HTTP table

i did this for MSN and saved them a whole bunch of effort

 

[Douglas J Steele]

Depends on how you did it.

It was possible to use the MS Remote provider, but RDS is considered to be
obsolete, and it can be very unsecure if not configured properly.

Alternatively, you can use an XML Web Service.

You can't, however, specify an HTTP URL rather than a URL or mapped drive.

 

[Guest]

Thank you I will try it.

What exactly do you mean by importing from an ftp site? Are you hoping to
import tables from the database? If so, I'm afraid you're out of luck:
Access doesn't recognize the FTP protocol (nor the HTTP protocol, for that
matter).

On the other hand, if all you're trying to do is download the database,
since a MDB file is binary, not text, you'd need to use the Binary method.

 

[dbahooker]

you think that i give a damn what microsoft claims to be insecure?

do you really think that MS is ALLOWED TO sell us a product and then
say 'oh, it's best if you dont use this'

they sold us shit they will fix it or close up shop.

they sold us shit and now they're not supporting it?

why do we put up with this crap?

 

[dbahooker]

more importantly-- SQL Server allows you to pull from a FTP drive..
right?

i wish that they would make this shit more powerful instead of just
rewriting it for the shits and giggles of it

i mean-- being able to save db data via ftp would be quite nice in my
opinion

 

[Guest]

Hi David,

I am doing something that might work for you. I created a DOS batch file to
download a zipped table, PKUNZIP the file and then append to an ACCESS table.
Just click on a menu button from ACCESS and viola it happens. Just bring it
over in a format that you can transfer in (TransferDatabase).

Bonnie