Adding excel Data into an already built DB table

[bittorents]

Windows XP Pro, Office 2000 Pro

We've recently changed over from and inventory workbook to an Access DB. However, I'm still getting data from our remote offices. Is there a way to parse that information into my current db table from excel? If this is possible, it would greatly reduce the amount of time spent on manual single cell entry.

As always, thanks to all in advance.

 

[PHV]

You may either play with access table linked to excel sheet or with the DoCmd.TransferSpreadsheet method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[bittorents]

Hi PHV, thank you for your response. I have to admit, I'm not any good at VB. Do I have to create an expression or macro in order to use DoCmd?

Thank you, I appreciate your help.

 

[MichaelRed]

just refer to the ubiquitous {F1} with the keyword
"TransferSpreadsheet"




MichaelRed

 

[randy700]

bittorents,

You can use the DoCmd method in the code of a routine or function in either a module or form. You can also use it as part of a macro.


Randy