@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.
