| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel & Access
Is there a way to take data from an excel spreadsheet and drop it into a microsoft access database? (Other than copying and pasting field by field) -- KuraofTyren ------------------------------------------------------------------------ KuraofTyren's Profile: http://www.excelforum.com/member.php...o&userid=24467 View this thread: http://www.excelforum.com/showthread...hreadid=380697 |
|
#2
|
|||
|
|||
|
From Access:
File-Get External Data. Pick your spreadsheet. ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "KuraofTyren" wrote in message ... Is there a way to take data from an excel spreadsheet and drop it into a microsoft access database? (Other than copying and pasting field by field) -- KuraofTyren ------------------------------------------------------------------------ KuraofTyren's Profile: http://www.excelforum.com/member.php...o&userid=24467 View this thread: http://www.excelforum.com/showthread...hreadid=380697 |
|
#4
|
|||
|
|||
|
This might be a help for getting data to and from Excel and Access: It
includes examples of using variables in SQL queries. http://www.bygsoftware.com/examples/sql.html Or you can get there from the "Excel with Access Databases" section on page: http://www.bygsoftware.com/examples/examples.htm It demonstrates how to use SQL in Excel's VBA to: * create a database, * create a table * insert records * select records, * update records, * delete records, * delete a table, * delete a database. DAO and ADO files available. You can also download the demonstration file called "excelsql.zip". The code is open and commented. -- Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy - "KuraofTyren" wrote in message ... Is there a way to take data from an excel spreadsheet and drop it into a microsoft access database? (Other than copying and pasting field by field) -- KuraofTyren ------------------------------------------------------------------------ KuraofTyren's Profile: http://www.excelforum.com/member.php...o&userid=24467 View this thread: http://www.excelforum.com/showthread...hreadid=380697 |
|
#5
|
|||
|
|||
|
Awesome :D Thanks guys :) -- KuraofTyren ------------------------------------------------------------------------ KuraofTyren's Profile: http://www.excelforum.com/member.php...o&userid=24467 View this thread: http://www.excelforum.com/showthread...hreadid=380697 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| my data truncates when ported from access to excel | Excel Worksheet Functions | |||
| Microsoft Access Report into Excel Spreadsheet | Excel Discussion (Misc queries) | |||
| How do I get an Access form in Excel to Expand the Data | Excel Discussion (Misc queries) | |||
| Linking Excel to Access. | Excel Discussion (Misc queries) | |||
| Managing an Access Database from Excel | Excel Discussion (Misc queries) | |||
Linear Mode
