السلام عليكم ورحمة الله وبركاته Dear All Master Access, 1. Saya punya 1 file txt, jika dibuka isinya spt terlampir di bawah ini.. Bagaimana memisahkan masing² Tabel & Fieldnya dengan Ms. Access..?? ( delimited : ~ ) karena masing² tabel beda jumlah fieldnya 2. Bagaimana caranya supaya tabel yang sudah terpecah(split) tadi dapat otomatis tereksport menjadi dbf ? Sekian, atas bantuannya saya ucapkan terima kasih banyak. Jazakumulloh khoiron katsiron. ﻮاﻠﺴﻼﻢ ﻋﻠﻴﻜﻢ ﻮﺮﺤﻤﺔ ﺍﷲ ﻮﺒﺮكاﺘﻪ
Eko PS Tabel1 N~0014420~Pitoyo Sardjono~01~BAE~9514403~Tri Sunu Rinekso~ ~ N~0014423~Andi Purwanto~01~BAE~9514403~Tri Sunu Rinekso~ ~ N~0014447~Herlanita Reikasari~01~CAD~0722410~Rosalia Rina Susilowati~ ~ N~0114402~Bowo Nurkriswanto~01~BAF~9514403~Tri Sunu Rinekso~ ~ N~0114410~Siswantoro~01~CAH~9614414~Ikhwan Nugroho~ ~ Tabel2 N~J00NA0034-08-000012878~04/01/2008~0722406~ ~ ~0822402~0114469~0034-04-000000224 N~J00NA0034-08-000012879~04/01/2008~0514586~ ~ ~0114461~0114461~0034-04-000000783 N~J00NA0034-08-000012880~04/01/2008~0514586~ ~ ~0114461~0114461~0034-04-000001862 N~J00NA0034-08-000012881~04/01/2008~0514586~ ~ ~0114461~0114461~0034-04-000001522 N~J00NA0034-08-000012882~04/01/2008~0514586~ ~ ~0114461~0114461~0034-04-000002657 Tabel3 N~1101~TIPE~HYPERMARKET NASIONAL~Tipe Pelanggan N~1102~TIPE~SUPERMARKET NASIONAL~Tipe Pelanggan N~1103~TIPE~MINIMARKET NASIONAL~Tipe Pelanggan N~1104~TIPE~HYPERMARKET REGIONAL~Tipe Pelanggan N~1105~TIPE~SUPERMARKET REGIONAL~Tipe Pelanggan N~1106~TIPE~MINIMARKET REGIONAL~Tipe Pelanggan N~1107~TIPE~HYPERMARKET LOKAL~Tipe Pelanggan N~1108~TIPE~SUPERMARKET LOKAL~Tipe Pelanggan N~1109~TIPE~MINIMARKET LOKAL~Tipe Pelanggan Tabel4 N~92606111201100~92606111201100~NMS15S N~92003621349100~92003621349100~NP10RA N~90101331405100~90101331405100~JCOP9 N~92706441509100~92706441509100~FL250D N~92706411101100~92706411101100~EK9V1 N~92706441501100~92706441501100~EC2AAF
Tabel1 N~0014420~Pitoyo Sardjono~01~BAE~9514403~Tri Sunu Rinekso~ ~ N~0014423~Andi Purwanto~01~BAE~9514403~Tri Sunu Rinekso~ ~ N~0014447~Herlanita Reikasari~01~CAD~0722410~Rosalia Rina Susilowati~ ~ N~0114402~Bowo Nurkriswanto~01~BAF~9514403~Tri Sunu Rinekso~ ~ N~0114410~Siswantoro~01~CAH~9614414~Ikhwan Nugroho~ ~ Tabel2 N~J00NA0034-08-000012878~04/01/2008~0722406~ ~ ~0822402~0114469~0034-04-000000224 N~J00NA0034-08-000012879~04/01/2008~0514586~ ~ ~0114461~0114461~0034-04-000000783 N~J00NA0034-08-000012880~04/01/2008~0514586~ ~ ~0114461~0114461~0034-04-000001862 N~J00NA0034-08-000012881~04/01/2008~0514586~ ~ ~0114461~0114461~0034-04-000001522 N~J00NA0034-08-000012882~04/01/2008~0514586~ ~ ~0114461~0114461~0034-04-000002657 Tabel3 N~1101~TIPE~HYPERMARKET NASIONAL~Tipe Pelanggan N~1102~TIPE~SUPERMARKET NASIONAL~Tipe Pelanggan N~1103~TIPE~MINIMARKET NASIONAL~Tipe Pelanggan N~1104~TIPE~HYPERMARKET REGIONAL~Tipe Pelanggan N~1105~TIPE~SUPERMARKET REGIONAL~Tipe Pelanggan N~1106~TIPE~MINIMARKET REGIONAL~Tipe Pelanggan N~1107~TIPE~HYPERMARKET LOKAL~Tipe Pelanggan N~1108~TIPE~SUPERMARKET LOKAL~Tipe Pelanggan N~1109~TIPE~MINIMARKET LOKAL~Tipe Pelanggan Tabel4 N~92606111201100~92606111201100~NMS15S N~92003621349100~92003621349100~NP10RA N~90101331405100~90101331405100~JCOP9 N~92706441509100~92706441509100~FL250D N~92706411101100~92706411101100~EK9V1 N~92706441501100~92706441501100~EC2AAF
