الفريق العربي للبرمجةأرشيف المنتديات · 2000 – 2023
نسخة أرشيفية للقراءة فقط — التسجيل والمشاركة مغلقان، والمحتوى محفوظ كما كان.

التعامل مع ملفات CSV

مغلق
بدأه hayl في 30 أكتوبر 2006 · 2 رد · 615 مشاهدة · في قواعد بيانات Microsoft Access
مشاركة: واتساب X فيسبوك تيليجرام
#1 صاحب الموضوع

السلام عليكم

لدى ملف CSV بالشكل التالى

Title Line("DATE","TIME","A/M")
Title Line(Measurement point number)
1st data line (year/month/day,hour/minute,auto,manual)
1st data line (Measurement point number)
2nd data line (year/month/day,hour/minute,auto,manual)
2nd data line (Measurement point number)
3rd data line (year/month/day,hour/minute,auto,manual)
3rd data line (Measurement point number)

مثال على البيانات

"DATE","TIME","A/M"
2150(STAT),2150(DATA),2151(STAT),2151(DATA),2152(STAT),2152(DATA),2153(STAT),2153(DATA),2154(STAT),2154(DATA),2160(STAT),2160(DATA),2161(STAT),2161(DATA),2162(STAT),2162(DATA),2163(STAT),2163(DATA)
"2006/10/10","00:01:30","A"
"NORMAL",," ",99.999," ",99.999," ",99.999," ",99.999," ", 0.423," ", 0.441," ",34.827," ",44.811
"2006/10/10","00:03:30","A"
"NORMAL",," ",99.999," ",99.999," ",99.999," ",99.999," ", 0.423," ", 0.441," ",31.332," ",39.195
"2006/10/10","00:05:30","A"
"NORMAL",," ",99.999," ",99.999," ",99.999," ",99.999," ", 0.426," ", 0.441," ",31.332," ",39.195
"2006/10/10","00:07:30","A"
"NORMAL",," ",99.999," ",99.999," ",99.999," ",99.999," ", 0.425," ", 0.441," ",34.827," ",44.811
"2006/10/10","00:09:30","A"
"NORMAL",," ",99.999," ",99.999," ",99.999," ",99.999," ", 0.424," ", 0.441," ",31.332," ",44.811
"2006/10/10","00:11:30","A"
"NORMAL",," ",99.999," ",99.999," ",99.999," ",99.999," ", 0.423," ", 0.441," ",31.332," ",44.811
"2006/10/10","00:13:30","A"
"NORMAL",," ",99.999," ",99.999," ",99.999," ",99.999," ", 0.424," ", 0.442," ",31.332," ",44.811
"2006/10/10","00:15:30","A"
"NORMAL",," ",99.999," ",99.999," ",99.999," ",99.999," ", 0.423," ", 0.441," ",31.332," ",44.811
"2006/10/10","00:17:30","A"
"NORMAL",," ",99.999," ",99.999," ",99.999," ",99.999," ", 0.425," ", 0.441," ",31.332," ",44.811

كيف اتمكن من إستدعاء البيانات من هذا الملف إلى جدول بشكل يمثل فيه كل سطر واحد قيمة

وجزاكم الله خيراً

#2

اخي الكريم

بعد اللتحية والاحترام

بالنسبة لي انا مرة احتجت اصدر البيانات من جدول اكسس الى ملف مشابة لملفك بصيغة csv

وفعلا قمت بالتصدير عن طريق اعطاء امر التصدير الى text file ونجحت العملية

انت الان تطلب العكس

اذا ادخل الاكسس واطلب استيراد ملف جديد بصيغة text file

واتوقع تمام ان شاالله

هذا اللي اعرف اتمنى يكون صح

#3

شكراً جزيلاً على الإهتمام والرد

الإستيراد إلى الاكسيس لا توجد مشكله فى قبول إستيراد او تصدير هذا النوع من الملفات او هذا التنسيق

لكن السطور يكون كل السطور الفردية هى لصفوف واحدة

وكل قيم زوجية لصفوف واحدة

هذا الموضوع مغلق.

مواضيع مشابهة