|
microsoft access question
|
View this Thread in Original format
| tranceaholic |
| ok i have this table, now the data i want to put in the table is an excel file..i dont want to reenter the data..is there a way i can export from excel to access or merge both..it will take me forever to renter all this data..any ideas? |
|
|
| PEZ68 |
yes , not very difficult.
send me your database if you want |
|
|
| tranceaholic |
| if you would explain it to me the steps that would be easier as the excel file is huge.thanks for the help |
|
|
| PEZ68 |
oops , sorry , I thought you want to put on excel , data from an access table.
The opposite should not be more difficult . Let me do some tests and I will recontact you
btw , have you some concepts in VBA? |
|
|
| Agent_WD40 |
It is fiarly simple to do, depending on the formatting of the spreadsheet that is. In Access go to:
File -> Get External Data -> Import
(be sure to select Excell as your file type)
and select your file. This should get you going in the right direction. Let me know if you need more help. |
|
|
| PEZ68 |
or he could try something like that :
DoCmd.TransferSpreadsheet acImport, , "Table_Name", "C:\Documents and Settings\Book1.xls", 0 |
|
|
| DeepSix |
| You should be able to just copy and paste. Select the data in excel and copy. Then create a new table in access with the correct number of columns. Then click the square in the upper left corner of the table (in datasheet view) and paste. |
|
|
| tranceaholic |
| quote: | Originally posted by Agent_WD40
It is fiarly simple to do, depending on the formatting of the spreadsheet that is. In Access go to:
File -> Get External Data -> Import
(be sure to select Excell as your file type)
and select your file. This should get you going in the right direction. Let me know if you need more help. |
thanks for the help...that way worked like a charm..and fairly easy..i was gonna write vb code for it but this saves the energy..thanks alot. |
|
|
|
|
