Can any one help me to create excel macro to upload,edit,delete bulk data in acceess

%3CLINGO-SUB%20id%3D%22lingo-sub-2442412%22%20slang%3D%22en-US%22%3ECan%20any%20one%20help%20me%20to%20create%20excel%20macro%20to%20upload%2Cedit%2Cdelete%20bulk%20data%20in%20acceess%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2442412%22%20slang%3D%22en-US%22%3E%3CP%3Ecan%20any%20one%20share%20macro%20codes%20to%20bulk%20upload%20data%20from%20excel%20to%20access%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2442412%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2442670%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20any%20one%20help%20me%20to%20create%20excel%20macro%20to%20upload%2Cedit%2Cdelete%20bulk%20data%20in%20acceess%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2442670%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F489903%22%20target%3D%22_blank%22%3E%40sangeethbabu%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.herber.de%2Fforum%2Farchiv%2F864to868%2F867889_Daten_exportieren_nach_Access.html%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%3CSPAN%3EDaten%20von%20Excel%20nach%20access%3C%2FSPAN%3E%3C%2FA%3E%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3ESub%20Excel_to_Access%20()%0A%0Adim%20db%20as%20database%0A%0Adim%20rs%20as%20recordset%0A%0Aset%20db%20%3D%20opendatabase%20(%22your%20database%22)%0A%0Aset%20rs%20%3D%20db.TableDefs%20(%22table%20name%22).%20Openrecordset%20(dbopendynaset)%0A%0Ars.addnew%0A%0Ars!%20field1%20%3D%20%5BA1%5D%0A%0ARS!%20Field2%20%3D%20%5BC60%5D%0A%0Aetc.%20for%20all%20columns%0A%0Ars.Update%0A%0Ars.close%0A%0Adb.close%0A%0AEnd%20Sub%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDatabase%20name%2C%20table%20name%20and%20field%20names%20have%20to%20be%20adjusted%2C%20of%20course.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fmove-data-from-excel-to-access-90c35a40-bcc3-46d9-aa7f-4106f78850b4%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EMove%20data%20from%20Excel%20to%20Access%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EIn%20his%20article%20shows%20you%20how%20to%20move%20your%20data%20from%20Excel%20to%20Access%20and%20convert%20your%20data%20to%20relational%20tables%20so%20that%20you%20can%20use%20Microsoft%20Excel%20and%20Access%20together.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20any%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20Community%20members%20reading%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

can any one share macro codes to bulk upload data from excel to access

1 Reply

@sangeethbabu 

 

Daten von Excel nach access

Sub Excel_to_Access ()

dim db as database

dim rs as recordset

set db = opendatabase ("your database")

set rs = db.TableDefs ("table name"). Openrecordset (dbopendynaset)

rs.addnew

rs! field1 = [A1]

RS! Field2 = [C60]

etc. for all columns

rs.Update

rs.close

db.close

End Sub

 

Database name, table name and field names have to be adjusted, of course.

 

 

Move data from Excel to Access

In his article shows you how to move your data from Excel to Access and convert your data to relational tables so that you can use Microsoft Excel and Access together.

 

I would be happy to know if I could help.

 

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.