Importing data from an Excel spreadsheet

[amagan]

I would greatly appreciate help in importing data from an Excel spreadsheet into an Access database. I am using Access97 on a Dell portable with W98SE.

I have an Excel spreadsheet (test1.xls) with 4 columns and 7 rows, populated with text in each cell.
I want to create an Access database (test1) with 4 columns and 7 rows and move the Excel data into test1..

Just how do I do that?

(I am brand new to Access. I have tried to follow the Access Help instructions and the instructions in a How-to manual but have not been able to do the importing. I am afraid I need some very basic hand-holding. Thanks for your patience.)

 

[Kiwiman]

Howzit
L
ook into the TransferSpreadsheet options - create a new macro and look at the requirements there.

Alternatively you can create a link (Right Click \ Link Tables \ Files of Type = Excel) in access to the spreadsheet. You can then open the linked table in access. You can then run a "Make table" query, to create your test table.

You can also do this in vb, but this should get you started

 

[Chrisopia]

I did it the other way around, I created the data in Access then exported it to create a raw Excel file with all the settings ready and correct to import them back into Access when data has been entered.

I found making sure the fields are the same types the hardest part, so this method sets up the excel file ready for data importing.

Hope this helps?

To import an excel file, use the TranferSpreadsheet macro option like kiwiman said

 

[amagan]

Howzit: Thank you for your help.
How do I get to "TransferSpreadsheet" from the opening Access screen? I can't find it anywhere. I get no optionns under "Macros".

 

[Kiwiman]

Howzit

Create a new macro and add an action transferspreadsheet. Fill in the necessary details. Look at the help for thsi action.

Cheers Les