Insert record from Data Table to Access

Good morning everyone :slight_smile:

OBJECTIVE: i would like to insert all record from my data table to access
DATA TABLE: dt_Original_Table (RefNum, DateCreated, Type, Category, Amount)
ACCESS TABLE: TEST (RefNum,DateCreated, Type, Category, Amount)

NOTE: All record in dt_Original_Table came from excel file (all data type is string if i’m no mistaken).

QUESTION: how can i insert record from data table to access. with access data type perspective. like if the DateCreated column in dt_Original_Table is String and auomatically converted as Date/TIme in access.

Hi @arthurang ,

Check this below link,

Hope this may help you :slight_smile:

4 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.