Add data from Excel

[44nato44]

Now I have been looking all over the internet and have not been able to find anything I can use.

The only thing I want is to take data from an excel sheet and copy it to the ms access database.

The only thing which comes to mind is take one field per time, which cannot be right.

I am not sure if creating a range in the excel sheet would be an idea, or make the sheet into a recordset and copy the data to the database that way.

I hope somebody has some nice code I can use.

Cheers

 

[44nato44]

and it needs to be done with code, as it needs to be automatically

 

[PHV]

Have a look at the DoCmd.TransferSpreadsheet method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[44nato44]

Sorry not my day to write this.. the code run in one MS Access database and writes to another

This is because we are linking data to the main MS Access database where the load form reside.

I do not believe I can use transferspereadsheet to import to another MS Access ?

 

[PHV]

So, Have a look at the DoCmd.TransferDatabase method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[44nato44]

hrmmm.. I looked at it and it does not make much sense to me

Can you advice how it will look if I want to import an excel sheet into a ms access DB which is not the one where the code is running on ?

Thanks

 

[PHV]

I do not believe I can use transferspereadsheet to import to another MS Access
Can't you import to a linked table ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[44nato44]

I see where you are going, but the database is password protected and I am not sure I can password protect a single linked table

Then I will need to set up user permissions which I am not interested in

So if there is a way to no have this database linked or anything that would be the best.

I might just be a bit out of my league or what I want to do is a bit complicated.