From Excel to Access

[celia2]

Hi,

Can someone point me some example/sample for the coding to export data from Excel to Access or vice versa? I am doing a timesheet in Excel and would like to collect the timesheet data into Access database where I can do the other calculations. I create the table alredy but not sure how to get the data into the Access table.

Very much appreaciate if someone can help on this.

Thankyou.

celia

 

[DJN]

It is probably easier to import the data from Excel whilst in Access. Have a look at the TransferSpreadsheet method in the Access help. There are also plenty of examples on this forum.

 

[modest]

Agreed, TransferText - TransferSpreadsheet - TransferTable

Click on search above and type any of those in.. even add "excel" to the search. There are plenty of examples in this forum.

-modest

 

[celia2]

Thanks for your reply.

However, I must have the data to transfer from excel to Access because the every time new data are entered in the excel spreadsheet. Some of the related cell/ data are then stored in aacess database for further actions.
So, I think coding are needed to be in either Excel or Accesss for the purpose.

Any one have any other reference on these.

Thankyou,
celia

 

[Bachatero]

you can directly link an excel spreadsheet as table into access

 

[modest]

However, I must have the data to transfer from excel to Access because the every time new data are entered in the excel spreadsheet. Some of the related cell/ data are then stored in aacess database for further actions.
So, I think coding are needed to be in either Excel or Accesss for the purpose.

You want to dynamically transfer data from excel to access... every time data is changed in the excel file?
If this is the case, use a linked table as Bachatero suggested.

If not, you could go to babelfish.altavista.com. It's a translator site, which might be easier on you to type what you want out in your language and then convert to english?

-modest

 

[Epic]

opinion

...

If not, you could go to babelfish.altavista.com. It's a translator site, which might be easier on you to type what you want out in your language and then convert to english?

-modest

I see that you know the answers to all questions but there are others who don't, and actualy they may need help... This is a public forum and is not open only for the good "english speakers".

wouldn't be better to keep this kind of idea for yourself?