acCmdImport Help!

[branston]

Hi.
I am tryign to find out a bit more about the import function in access. I have had a look but i cant seem to find anything that give you an overview of what it does and how it works etc. Does anyone know of a link, or willing to explain?

Thanks!

 

[Steve R.]

If you have Access 2007 type in "acImport" in VBA help and you will have some examples to review. Alternatively you can do a search on "DoCmd" in VBA help. (If you have an earlier version of Access, Access "help" may or may not work as expected.)

 

[branston]

Help just gives me a huge list of Ac... showing the possible constants and their values...

 

[Atomic Shrimp]

If you're using one of the Transfer functions such as TransferSpreadsheet or TransferText, acImport is one of the types you can specify - it tells Access to import the data as a table. acLink tells Access to create a linked table and acExport is for exporting an existing table or query to text files, spreadsheets, other databases, etc.

Without knowing what you're after, it's a bit difficult to know what more to say.

 

[branston]

Thanks, From that I think what im looking for is TransferSpreadsheet... What im basically trying to do is this:
I have a excel sheet which is regularly updated. I need to update a table in my Db from this excel sheet. At the moment im copy & pasting the fields in, but i thought if there was an automatic way of doing it it would save time.
Thanks again for your help so far.