Importing Excel Spreadsheet Limitations?, Access 2016
Apr 16 2017, 08:31 PM
Joined: 31-January 07
From: South Australia
I'm doing a lecture on my piano tuning customer database at our next convention and I am sure that Tuners that might want to use it will ask if they can import their present Excel database spreadsheet. I have done it before when getting the list of Delegates from a past convention but would like to know the limitations. I know how to import into a table that the headers have to be exactly the same as what is in the Access table but I forgot if I changed the spreadsheet to only have the Access headers. The question is: What happens when only 10 out of 15 headers are the same as the Access table, will it only import the 10 similar headers or will the whole import fail?
Apr 16 2017, 10:00 PM
Access Wiki and Forums Moderator
Joined: 19-June 07
You'll have to test but as far as I know, Access will only import what it can match with the existing table.
Apr 16 2017, 10:56 PM
Joined: 20-June 02
From: Newcastle, WA
I believe it will import only those fields that match. However, that's not really very useful, in any event. If the missed fields contain important data, you'll have to revise the import to accommodate it anyway I would imagine.
|Search Top Lo-Fi||27th April 2017 - 11:38 AM|