Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Spreadsheet into Access Table

Status
Not open for further replies.
TravTrav

TravTrav

IS-IT--Management
Jun 4, 2002
115
US
Hello All,
Here is what I want to do. I want to have an excel spreadsheet on a form dump information by cell into an access table. Just started dealing with Access this week, so I have no clue how to do this.

Thanks,
Travus
 
Sort by date Sort by votes
I am not sure what you are trying to do, but the easiest way to get Excel worksheet data into Access is to go into your Access database, and click New table, import table and choose Excel as the type, then just select your Excel worksheet. Answer the questions as they are asked, and you should be OK.

Sawedoff

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Question
Excel Pivot Table - Combine Values into a single row
Replies
16
Views
2K
remeng
remeng
bkoopers
  • Locked
  • Question
Problem with Excel pasting into filtered cells
Replies
1
Views
307
combo
combo
E
  • Locked
  • Question
Extract lines from table into new table
Replies
2
Views
784
SkipVought
S
E
  • Locked
  • Question
Copying spreadsheet for posting
Replies
2
Views
460
combo
combo
remeng
  • Locked
  • Question
Power Query Split by Table Group by Rows into a new set of group by tables
Replies
2
Views
400
remeng
remeng

Part and Inventory Search

Sponsor

Back
Top