Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Expot to Access
Hi
I need to export data in a worksheet to an access DB table, however due to the amount of data, exporting row by row is very long. Is there a way where i can export the entire sheet in one go with columns representing fields in the table? Any help would be greatly appreciated. CHeers STuart |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Expot to Access
Stuart
You can select the data in Excel and Copy. Open Access if you have already creaded the database use Edit, Paste-Append. The data will be added to existing data. Access will produce an error message and a table of errors that you should be able to delete (but check first). If the Table has not been created then create a new table in TAble view and Paste Append the data again. You can alter the Field Names Later in design View. Refards Peter -----Original Message----- Hi I need to export data in a worksheet to an access DB table, however due to the amount of data, exporting row by row is very long. Is there a way where i can export the entire sheet in one go with columns representing fields in the table? Any help would be greatly appreciated. CHeers STuart . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Expot to Access
One way or another all the data (same amount whichever way you choose) has
to be transferred from A to B. Try some alternatives. Which way is safer (probably no difference)? Which way are YOU most comfortable with (YOU have to answer for the results!)? Which is easier for YOU to maintain? As an alternative why not try these ways of 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 and add data to it, * select data from a table, * 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 -- Regards Andy Wiggins www.BygSoftware.com Home of "Save and BackUp", "The Excel Auditor" and "Byg Tools for VBA" "Stuart Greville" wrote in message ... Hi I need to export data in a worksheet to an access DB table, however due to the amount of data, exporting row by row is very long. Is there a way where i can export the entire sheet in one go with columns representing fields in the table? Any help would be greatly appreciated. CHeers STuart |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query from Access into Excel cause Access to go to read only | Excel Discussion (Misc queries) | |||
Can Excel access data from Access?! | Excel Discussion (Misc queries) | |||
Access Form In An Access Report (SubForm) Question | Links and Linking in Excel | |||
export access to excel. change access & update excel at same time | Excel Discussion (Misc queries) | |||
How to access ACCESS from Excel! | Excel Programming |