mrtauntaun
MIS
Hi. I am trying to import an excel spreadsheet into an existing access table. However, the option to select an existing table is greyed out. Any ideas? Thanx!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Importing spreadsheets into an existing table/form? 1
- Thread starter mrtauntaun
- Start date
- Status
-
1
- #2
Hi,
If the fields are different, or if a field has one data type in Excel and another in Access that can screw up the works.
For what its worth, I've found that you get a bit more control over the whole thing if you import excel as a new table (play with any field names/data types, etc), then use an append query to get all the data into the table where you want it end up.
Good luck,
CJ
If the fields are different, or if a field has one data type in Excel and another in Access that can screw up the works.
For what its worth, I've found that you get a bit more control over the whole thing if you import excel as a new table (play with any field names/data types, etc), then use an append query to get all the data into the table where you want it end up.
Good luck,
CJ
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question