Query to import data from excel 2007

ootkhopdi

Registered User.
Local time
Tomorrow, 03:42
Joined
Oct 17, 2013
Messages
181
Hello


i have an access file in which have a table name dataupdated

i have an excel 2007 file(Datanew) which have a sheet name data
i want to update table dataupdated at regular period
pls give me solution
how can i create a query to import data from excel while file path and sheet name is always same and other steps to import data is same every time

pls help me
 
Hello,
1- Look the help of the "Docmd.TransferSpreadSheet" method to import your Excel sheet in a passing table "Tableprov".
2- Delete data in your table "dataupdated" with a Delete Query
3- Add data from "Tableprov" in "dataupdated" with an INSERT query.

Good continuation
 
Thanks madefemere

but i can't understand the "Docmd.transferspreadsheet" method

pls give me step by step solution and if possible with en example

thanks in advance
 
Thanks once again madefemere

but there is a little prob with me that
i have excel file with 4 sheets, named data, dataupdated,dataex and rough

i want to import data from sheet "dataupdated"
how can i select this sheet in file
thanks once again
 

Users who are viewing this thread

Back
Top Bottom