I have a database with existing tables.
I now want to add a whole bunch of records into my access tables.
A lot of the data is repeated, and lends itself to my doing it in excel with it's better copy and paste abilities, and it's ability to easily increment alphanumeric fields.
I can't seem to succeed in append importing to the bottom of my access table from my excel spreadsheet. All columns are the same.
Can this be done, and if so how please?
I'm on XP Pro with Office 2003 Pro.
I'm also very much a newbie in Access.
I now want to add a whole bunch of records into my access tables.
A lot of the data is repeated, and lends itself to my doing it in excel with it's better copy and paste abilities, and it's ability to easily increment alphanumeric fields.
I can't seem to succeed in append importing to the bottom of my access table from my excel spreadsheet. All columns are the same.
Can this be done, and if so how please?
I'm on XP Pro with Office 2003 Pro.
I'm also very much a newbie in Access.