VBA code to append data (1 Viewer)

Ossama22 · Nov 20, 2018

Hello guys ,
Could you please help me about if there any VBA code to append data from excel to access , i mean i have a table linked to form i need a button when i press on it all the data in excel file (in a specific destination in my pc) appended to this table , is that possible.

Ranman256 · Nov 20, 2018

append query.
either link the xl file as an external table then run append query
or
run the transfer :
docmd.TransferSpreadsheet acImport ,acSpreadsheetTypeExcel12,sTable, sFile, true,sSheetName

Ossama22 · Nov 21, 2018

I follow the steps , but i dont know where’s the mistake , could you help plz ?

isladogs · Nov 21, 2018

That's giving me eye strain looking at your photo

Please use the print screen button to get a legible image, crop to what is needed then upload

Ossama22 · Nov 21, 2018

Iam sorry about the previous pic , here’s the screenshot

isladogs · Nov 21, 2018

You need quote marks around the table name, file name and range arguments.

Ossama22 · Nov 21, 2018

Iam sorry for being annoying, but iam still face some problems

isladogs · Nov 21, 2018

Unless you tell us what problems, we can't help.

BTW it's even easier to copy and paste the code here using the code tags # button in the reply.

Ossama22 · Nov 21, 2018

Private Sub Command197_Click()
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "Copy Of Refernce", "N:\001 ALL FORM2", True, "Adding new", ""
End Sub

isladogs · Nov 21, 2018

Ok you copied the code though didn't use the code tag button.
What's the problem?

EDIT: The final part , "" does nothing and should be removed

VBA code to append data (1 Viewer)

Ossama22

Registered User.

Ranman256

Well-known member

Ossama22

Registered User.

Attachments

isladogs

MVP / VIP

Ossama22

Registered User.

Attachments

isladogs

MVP / VIP

Ossama22

Registered User.

Attachments

isladogs

MVP / VIP

Ossama22

Registered User.

isladogs

MVP / VIP

Similar threads

Users who are viewing this thread