How To Import Excel Into Access

[rockart]

sounds easy.
am a little green at this.
created an access table from an excel file
not linked, just an access table
created a form for this, nice and pretty for data entry and to view records without scrolling
now I want to add a bunch more records from an excel file to the existing table
The xl file is set up the same as the one I used to create the above access file(s).
Have tried everything i can think of.
Can someone please tell me the right way to go about this?
Help please

XP, ACCESS 2002

[MMcCarthy]

Link the excel file and create an apend query to add the data to the existing table.

Mary

[rockart]

Thank you Mary, but trying to do this, using Access Help, is confusing me no end. Is there a step by step somewhere I could be directed to please?

[kartikss]

Hi

if you want to import excel file into access then save the excel file and open the access file go to table option and right click and select import - select the file of type - microsoft excel and select the particular excel file - then wizard will open n do the needful things as per wizard.

try this option, it might work.

Thanks & Bye

Kartik

[angeldeveloper]

Hello just import your excel file to access

[MMcCarthy]

Thank you Mary, but trying to do this, using Access Help, is confusing me no end. Is there a step by step somewhere I could be directed to please?

1. Link the excel file to access.
2. Open a new query design window and add the linked table.
3. Go to query menu on the menu bar and select "Append Query".
4. You will be prompted for the table to append to.
5. As you add columns to the query the matching column in the table should appear in the "Append to:" line where the names match and if the column names don't match you can select the appropriate column from the dropdown list.

Mary

[rockart]

Thank you for the help. what I finally did was create a new table in Access from the excel file and paste records from there to the 'target' table.
The catch with copy and paste is one has to (unlike any copy and paste I have encountered) left click at the left most point - before any text - in the cell before doing teh usual drag across/down to select the required records/fields. The other catch is one has to select the exact number of fields/records in the target area before pasting or it will not work.Spreadsheets and MS Works (flat file database) don't have these requirements. Now I know.
Thanks again,