Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jhermiz
3564 Posts |
 Posted - 2006-01-10 : 10:22:29
|
I havent used excel or access in a while but all I wanted to do for an end user was import data from excel to access. So in access I went to import, it shows the data in excel, I click next...Then i want to append this data to an existing table but for some odd reason it is greyed out, the only option I have is to export the data directly into a new table...Was wondering if anyone knows if there is an issue with this or if I am missing something, or if there is a better way to do this ?Thanks
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-01-10 : 15:46:02
|
| Do u have the same structure in both data locations? (ie In Excel & Access)Also the data in each location are of same format (Excel not having different format of data, which Access table couldn't hold) ?Tried the other way, export from Excel? |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-01-11 : 12:32:29
|
| Can you DTS from XLS to Access? Might give you more flexibility.Kristen |
|
|
|
|
|
|
import data from excel