Computing.Net > Forums > Office Software > Excel to Infopath to Access 2003

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Excel to Infopath to Access 2003

Reply to Message Icon

Name: unsure2
Date: January 21, 2008 at 10:12:06 Pacific
OS: n/a
CPU/Ram: n/a
Product: n/a
Comment:

There is a weekly and monthly report that the managers at my company have to do. The data is copied and pasted on an Excel sheet and sent to higher ups. I would like to be able to keep all of this info in an Access database, but in a way that the data can be copied and pasted into an Infopath form that feeds into this database. I know how to link Infopath to Access, but is there a way to easily copy and paste from Excel to Infopath to Access? Or maybe just from Excel to Access? I just want the managers to be able to copy and paste all of the data instead of cell by cell or having to hand key all of the info into Infopath manually. The faster and easier the better...

thanks in advance!



Sponsored Link
Ads by Google

Response Number 1
Name: Jennifer SUMN
Date: January 21, 2008 at 10:43:16 Pacific
Reply:

Why not just link the Access Table to the Excel Workbook?

Life's more painless for the brainless.


0

Response Number 2
Name: unsure2
Date: January 21, 2008 at 10:51:05 Pacific
Reply:

I didn't even know that might be an option for us...is that a hard process? The Excel sheet came before the database did...


0

Response Number 3
Name: Jennifer SUMN
Date: January 21, 2008 at 12:10:43 Pacific
Reply:

Nope. Just do a new Table, but link to the Spreadsheet. The wizard will walk you through it...

Life's more painless for the brainless.


0

Response Number 4
Name: unsure2
Date: January 21, 2008 at 12:27:54 Pacific
Reply:

Great! Thanks a bunch!


0

Response Number 5
Name: Jennifer SUMN
Date: January 21, 2008 at 17:23:22 Pacific
Reply:

You're welcome.

Life's more painless for the brainless.


0

Related Posts

See More



Sponsored Link
Ads by Google
Reply to Message Icon

Nero issues Excel question



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: Excel to Infopath to Access 2003

Import .txt to Access 2003 www.computing.net/answers/office/import-txt-to-access-2003-/9668.html

Convet excel to Access www.computing.net/answers/office/convet-excel-to-access/5859.html

Importing Excel sheets to Access www.computing.net/answers/office/importing-excel-sheets-to-access/1774.html