Is it possible to upload files through a Access page/form?

[Guest]

I want to create a MS Access form or page where users can upload their .XLS
files. MS Access must handle this and put the files in a specific directory.

 

[Guest]

upload from where? from there desktop or other directory into a designated
area?

If so, yes, this can be done. you need to break it up into 2 tasks.

1- Get the files
The following link will allow you to call a open file dialog where your
users can select the files they want to upload
http://www.mvps.org/access/api/api0001.htm

2- move the files
Then you can process each file by either copying them to your designated
directory and/or deleting the original source copy

To copy:
Use FileCopy Source Destination

To Delete:
Use Kill File

Daniel

 

[Guest]

Hi Daniel, thanks for your answer! This is the situation:

A access form / page, users open this page through the internet and upload
their file. I want that access put this file in a special directory (for them
unknown) and that Access write this upload everytime to a specific table,
like last update on "01-01-2007".

Is that possible?

 

[Guest]

Hi,

I've created a button which call the function TestIt(), but please tell me
what I must do after i selected the file.

Is there a variable which contains this path when i make use of copyfile?

Kind regards, Stefan van der Hooft.