would take one Excel file, and import
specific Excel cells to one Access database record?
Then the script would prompt the user for another
file location, where the user would select the next
Excel file to import to Access as the next record.
This script would create a new Access record from the
active cells in the second Excel file. This script
would continue in a loop until there were not any more
Excel files to create new Access records.
Any ideas?
I have a script, however it does not work
correctly, and I am baffled.
Thanks,
Jeff
SPONSORED LINKS
| Microsoft access database | Database development software | Microsoft access development |
| Database management software | Inventory database software | Membership database software |
YAHOO! GROUPS LINKS
- Visit your group "AccessVBACentral" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
