| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transfering data/table from excell to access
I have a messy table, with valuable information on it, in excell. I was
wondering where ive set up a table in access with my own fields to make it tidy'er is there a way to transfer the information straight into that table?? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Transfering data/table from excell to access
Create a new database in Access and then click FILE, GET EXTERNAL DATA,
IMPORT to initiate the import process. Change the file type to Excel, locate the workbook and select the file. Then follow the on-screen directions to import the data into either a new or existing table. -- Kevin Backmann "Tobes" wrote: I have a messy table, with valuable information on it, in excell. I was wondering where ive set up a table in access with my own fields to make it tidy'er is there a way to transfer the information straight into that table?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can excell extract data from Access (hot line?) | Excel Worksheet Functions | |||
| transfering data from a table to a line graph | Charts and Charting in Excel | |||
| Data from Excel to Access Table | Excel Discussion (Misc queries) | |||
| Transfering From Excel to Access | Excel Discussion (Misc queries) | |||
| Ref Transfering Info from a table | Excel Discussion (Misc queries) | |||
Hybrid Mode
