M
M440W
Why I'm Doing this:
I have a user that wants to copy and paste data on an on going basis from
an Excel spreadsheet into an Access database I built. We would like to be
able to copy and paste several fields at a time. I believe this can be done
if I replace the exisiting Access table with a linked Excel table, but I
can't get it set-up.
What I did:
1. I exported the original Access table into Excel using the "Analyze with
Excel" icon on tool bar.
2. I deleted the original table from the database (kept a backup copy).
3. created a link to the new table using the link to Excel wizard.
Problems:
1. Fields that had been defined as "number fields" are now converted to
"text" in the new Excel table. How can I change them back?
2. The new Excel table does not have a primary key, so I can't create the
same type of relationship (one-to-many) that I had with the original table in
my database.
Thanks for any help.
I have a user that wants to copy and paste data on an on going basis from
an Excel spreadsheet into an Access database I built. We would like to be
able to copy and paste several fields at a time. I believe this can be done
if I replace the exisiting Access table with a linked Excel table, but I
can't get it set-up.
What I did:
1. I exported the original Access table into Excel using the "Analyze with
Excel" icon on tool bar.
2. I deleted the original table from the database (kept a backup copy).
3. created a link to the new table using the link to Excel wizard.
Problems:
1. Fields that had been defined as "number fields" are now converted to
"text" in the new Excel table. How can I change them back?
2. The new Excel table does not have a primary key, so I can't create the
same type of relationship (one-to-many) that I had with the original table in
my database.
Thanks for any help.