User Tools

Site Tools


vba:tutorials:importwithstage

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
vba:tutorials:importwithstage [06.06.2019 09:04:00]
yaslaw [Migrieren der Deals nach TBL_DEALS]
vba:tutorials:importwithstage [18.06.2020 09:31:27] (current)
yaslaw [Import]
Line 60: Line 60:
  
 Nun habe ich das folgende in meiner Tabelle STG_DEALS Nun habe ich das folgende in meiner Tabelle STG_DEALS
-<code text STG_DEALS>​id | user   | deal_date | amount ​            +<code text STG_DEALS>​id | user   | deal_date | amount ​            | user_id 
----|--------|-----------|------------------- +---|--------|-----------|--------------------|---------  
-3  | Hans   | 20170207 ​ | EUR 10.500,​00- ​    +3  | Hans   | 20170207 ​ | EUR 10.500,​00- ​    |  
-4  | Peter  | 20170208 ​ | USD 5.454,​00 ​      +4  | Peter  | 20170208 ​ | USD 5.454,​00 ​      |  
-5  | Sandra | 20170216 ​ | EUR 16.546.345,​35-</​code>​+5  | Sandra | 20170216 ​ | EUR 16.546.345,​35- ​</​code>​
  
 ===== Normalisieren der User ===== ===== Normalisieren der User =====
vba/tutorials/importwithstage.1559804640.txt.gz · Last modified: 06.06.2019 09:04:00 by yaslaw