Thank you. I tried your solution, but unfortunately we have so much garbage in the data source that importing a .txt file yields quotation marks everywhere. A simple find/replace won't get rid of them b/c quotation marks are used as abbreviations for foot/inch measurements in the description column.
How did you old timers manage to keep your sanity all this time?...
MarcGA
Last Activity: Aug 8 '07, 07:16 PM
Joined: Jul 30 '07
Location:
-
Import Excel to Access: many to one, superfluous blank lines
(Excel 2003, Access 2003, XP, novice user here)
I can't get Access to accept multiple Excel files to the same table. I can import the spreadsheets to a new table, but I need to import 23 spreadsheets to the same table. I'm not getting a formatting error, just a "file did not import" message.
Also, when I do import one-to-one, Access inserts thousands of blank lines before the first line of imported data. How... -
Thanks, Rabbit. Both Search and the browser search do about the same...comes down to tactical term selection. Oh well..couldn't find a topic with the same fact pattern. I'm usually the guy who asks the question that's been repeated the most! :(Leave a comment:
-
drop-down box - selection determines content of adjoining field
MS Access 2003/Win XP. I have a small table of legal entities and tax ID numbers. This table is a source for a larger tax registration table. On the larger table, the legal entity is selected from a drop-down list of legal entities (on the small table). The corresponding tax ID number never changes, so I want the tax ID field in the larger table to populate based on the legal entity that is selected. How do I enable one drop-down list to determine... -
My first post...quick search ???
Before I ask my question, is there a quick way to review all the pages and determine if my Access 2003 question has already been addressed? Thank you. (I know how to run a search on each page...just hoping there's a faster way...)
No activity results to display
Leave a comment: