perhaps there is a minor problem with your script that we as a group can
help you debug. Can you post it?
there are some snippets of code at my site that help read in data from
specific cells in a spreadsheet, but you would have to piece it together to
do the entire chunk you want done.
Richard
Richard "Manxman" Killey
MS Access Developer
for more MS Access tips, visit
http://www.accessdatabasetips.com
-----Original Message-----
From: [email protected]
[mailto:[EMAIL PROTECTED] Behalf Of jeffdeck2001
Sent: April 30, 2006 7:14 PM
To: [email protected]
Subject: [Access VBA Central] Excel to Access 2003
Do you have a VBA script for Access 2003 that
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
Yahoo! Groups Links
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.
