Prob. copying Excel cell contents to Access field names
Greetings software geniuses. In an Access table I have the design grid up, so I can change field names. In Excel, I have a column with the field names (which are nonnumeric).
If I highlight a cell, Ctrl-C, go to Access and hit Ctl-V and enter, Access rejects it.
If I F2 a cell, scrape the 6 letters, Ctrl-C, go to Access and hit Ctl-V and enter, Access accepts it.
It's as though there's a control character, like a line feed, in the copy buffer. Any ideas or suggestions? A VBA solution to get it in the copy buffer is okay; then i can just hit a hotkey in Excel to copy it, and move down to the next. (However, activecell.copy fell into the same trap.)
TIA. There are tons of fields, so any effort-saving counts here.
__________________
______
ON STRIKE. Thomas Jefferson and I are on strike against AO over a little matter called the First Amendment and censorship against dissenting views. I hereby choose to toss my voluntary contributions into the Harbor rather than accede in slavery to the oppressor.
|
09-26-2002, 03:46 PM
Threaded Mode