Importing Excel to Access through a form

[LB79]

Hello everyone.

Im trying to find some kind of tutorial on creating a form that opens a window allowing the user to select a file for import.

Does anyone know of any?

Thanks for any help!!

 

[jsv2002]

Do you just want to import the file location so the user can open the file or the actual "data" in the excel spreadsheet to a table in access?

 

[LB79]

Hi and thanks for your response.
I would like to have the excel data import directly to a table.

 

[DCrake]

You may need to bear in mind the following issues

1 will the user know the path to the specified location
2 What happens if the file is not there
3 has this file been imported before
4 does it contain the expected data
5 do you need to validate the data before importing it

David

 

[LB79]

Thanks for pointing those issues out and I will work around those once I have the basics sorted out.

 

[maddoctor]

And how can I tell to my mdb file to open an other mde file and import its table in my mdb file (like an update fuction)?

 

[DCrake]

Mde's do not usually contain tables, they are generally the front end element of the application. Mdb's that contain tables are the back ends. You need to refer to them.

David

 

[maddoctor]

Mde's do not usually contain tables, they are generally the front end element of the application. Mdb's that contain tables are the back ends. You need to refer to them.

David

I'm asking this because I have created an application which for security reason is mde and not mdb. All that I want is like excel, to be able to import tables from it.

 

[LB79]

Is anyone able to assist me with my original thread query?

Thanks

 

[jsv2002]

Never tried to automate it but try here for info:

http://office.microsoft.com/en-us/access/HP051866541033.aspx

Access 2003 command:

http://msdn.microsoft.com/en-us/library/aa220766.aspx

Access 2007 command:

http://msdn.microsoft.com/en-us/library/bb214134.aspx

Had a quick read and should give you the general idea of how to start.