Import excel into existing list (with data already in it)

B-Jayne Leuterman Yes, that's the beauty of using Access. Create a blank Access database. From the External Data menu, choose New Data Source - Online -> SharePoint list. Paste the URL of the base of your SP site and select "Link to the data source". Select one or more lists. If any of your lists contain Person column types, Access may bring in an additional table called UserInfo that contains user profile data of what are called "site users". These are the users that have accessed your SP site at some point in time.

If your SP list contains lookup columns, Access should also bring in the source lists of those lookup columns. For example, if your SP site has a list called Products and another list called Warehouses, and Products has a lookup column "Warehouse" that points to the Warehouses list, then linking to the Products list from Access should also bring in a link to the Warehouses list into Access.

You can copy and paste data into these lists, similar to what people in this forum are describing about the SP web-based list interface. You can also write SQL-like queries in Access that insert data into the SP list from another Access table or other data source.

Note that these SP lists appear in Access like tables, but are actually directly connected to the SP list. Therefore, changes/insertions you make in Access will immediately update the SP list online.