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
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...
Summary: I am trying to import a .txt file to Access 2003 with 3 row headers. How do I remove the headers after the page break and import columns based on what row it lines up on. I was thinking maybe there i...
Summary: Open Access Create a new database In a new Table File Get External Data Import Files of Type Microsoft Excel (xls) Browse to your Excel Spreadsheet Follow the prompts Very simple Life is more painless...
Summary: I am looking to import data from Excel to Access. The data is set up in one Excel file, but on 12 (monthly) sheets. After importing the first month/sheet (which I did successfully), I was looking to...