csv.Dateien einlesen

hallo zusammen!

Ich bräuchte Hilfe beim Import von .csv-dateien:
die ersten paar zeilen sehen ca. so aus:

GRDNO,a2_m_Bio4BE_2010,a2_m_Bio4BE_2020,a2_m_Bio4BE_2030,a2_m_Bio4BE_2 040,a2_m_Bio4BE_2050,a2_m_Bio4BE_2060,a2_m_Bio4BE_2070,a2_m_Bio4BE_208 0,a2_m_Bio4BE_2090,a2_m_Bio4BE_2100,a2_m_C_2010,a2_m_C_2020,a2_m_C_203 0,a2_m_C_2040,a2_m_C_2050,a2_m_C_2060,a2_m_C_2070,a2_m_C_2080,a2_m_C_2 090,a2_m_C_2100,a2_m_af_2010,a2_m_af_2020,a2_m_af_2030,a2_m_af_2040,a2 _m_af_2050,a2_m_af_2060,a2_m_af_2070,a2_m_af_2080,a2_m_af_2090,a2_m_af _2100,a2_b_af_2010,a2_b_af_2020,a2_b_af_2030,a2_b_af_2040,a2_b_af_2050 ,a2_b_af_2060,a2_b_af_2070,a2_b_af_2080,a2_b_af_2090,a2_b_af_2100,a2_m _df_2010,a2_m_df_2020,a2_m_df_2030,a2_m_df_2040,a2_m_df_2050,a2_m_df_2 060,a2_m_df_2070,a2_m_df_2080,a2_m_df_2090,a2_m_df_2100,a2_b_df_2010,a 2_b_df_2020,a2_b_df_2030,a2_b_df_2040,a2_b_df_2050,a2_b_df_2060,a2_b_d f_2070,a2_b_df_2080,a2_b_df_2090,a2_b_df_2100,a2_m_fin_for_2010,a2_m_f in_for_2020,a2_m_fin_for_2030,a2_m_fin_for_2040,a2_m_fin_for_2050,a2_m _fin_for_2060,a2_m_fin_for_2070,a2_m_fin_for_2080,a2_m_fin_for_2090,a2 _m_fin_for_2100,a2_b_fin_for_2010,a2_b_fin_for_2020,a2_b_fin_for_2030, a2_b_fin_for_2040,a2_b_fin_for_2050,a2_b_fin_for_2060,a2_b_fin_for_207 0,a2_b_fin_for_2080,a2_b_fin_for_2090,a2_b_fin_for_2100,a2_b_C_2010,a2 _b_C_2020,a2_b_C_2030,a2_b_C_2040,a2_b_C_2050,a2_b_C_2060,a2_b_C_2070, a2_b_C_2080,a2_b_C_2090,a2_b_C_2100,a2_b_Bio4BE_2010,a2_b_Bio4BE_2020, a2_b_Bio4BE_2030,a2_b_Bio4BE_2040,a2_b_Bio4BE_2050,a2_b_Bio4BE_2060,a2 _b_Bio4BE_2070,a2_b_Bio4BE_2080,a2_b_Bio4BE_2090,a2_b_Bio4BE_2100,b1_m _Bio4BE_2010,b1_m_Bio4BE_2020,b1_m_Bio4BE_2030,b1_m_Bio4BE_2040,b1_m_B io4BE_2050,b1_m_Bio4BE_2060,b1_m_Bio4BE_2070,b1_m_Bio4BE_2080,b1_m_Bio 4BE_2090,b1_m_Bio4BE_2100,b1_m_C_2010,b1_m_C_2020,b1_m_C_2030,b1_m_C_2 040,b1_m_C_2050,b1_m_C_2060,b1_m_C_2070,b1_m_C_2080,b1_m_C_2090,b1_m_C _2100,b1_m_af_2010,b1_m_af_2020,b1_m_af_2030,b1_m_af_2040,b1_m_af_2050 ,b1_m_af_2060,b1_m_af_2070,b1_m_af_2080,b1_m_af_2090,b1_m_af_2100,b1_b _af_2010,b1_b_af_2020,b1_b_af_2030,b1_b_af_2040,b1_b_af_2050,b1_b_af_2 060,b1_b_af_2070,b1_b_af_2080,b1_b_af_2090,b1_b_af_2100,b1_m_df_2010,b 1_m_df_2020,b1_m_df_2030,b1_m_df_2040,b1_m_df_2050,b1_m_df_2060,b1_m_d f_2070,b1_m_df_2080,b1_m_df_2090,b1_m_df_2100,b1_b_df_2010,b1_b_df_202 0,b1_b_df_2030,b1_b_df_2040,b1_b_df_2050,b1_b_df_2060,b1_b_df_2070,b1_ b_df_2080,b1_b_df_2090,b1_b_df_2100,b1_m_fin_for_2010,b1_m_fin_for_202 0,b1_m_fin_for_2030,b1_m_fin_for_2040,b1_m_fin_for_2050,b1_m_fin_for_2 060,b1_m_fin_for_2070,b1_m_fin_for_2080,b1_m_fin_for_2090,b1_m_fin_for _2100,b1_b_fin_for_2010,b1_b_fin_for_2020,b1_b_fin_for_2030,b1_b_fin_f or_2040,b1_b_fin_for_2050,b1_b_fin_for_2060,b1_b_fin_for_2070,b1_b_fin _for_2080,b1_b_fin_for_2090,b1_b_fin_for_2100,b1_b_C_2010,b1_b_C_2020, b1_b_C_2030,b1_b_C_2040,b1_b_C_2050,b1_b_C_2060,b1_b_C_2070,b1_b_C_208 0,b1_b_C_2090,b1_b_C_2100,b1_b_Bio4BE_2010,b1_b_Bio4BE_2020,b1_b_Bio4B E_2030,b1_b_Bio4BE_2040,b1_b_Bio4BE_2050,b1_b_Bio4BE_2060,b1_b_Bio4BE_ 2070,b1_b_Bio4BE_2080,b1_b_Bio4BE_2090,b1_b_Bio4BE_2100,b2_b_af_2010,b 2_b_af_2020,b2_b_af_2030,b2_b_af_2040,b2_b_af_2050,b2_b_af_2060,b2_b_a f_2070,b2_b_af_2080,b2_b_af_2090,b2_b_af_2100,b2_b_df_2010,b2_b_df_202 0,b2_b_df_2030,b2_b_df_2040,b2_b_df_2050,b2_b_df_2060,b2_b_df_2070,b2_ b_df_2080,b2_b_df_2090,b2_b_df_2100,b2_b_fin_for_2010,b2_b_fin_for_202 0,b2_b_fin_for_2030,b2_b_fin_for_2040,b2_b_fin_for_2050,b2_b_fin_for_2 060,b2_b_fin_for_2070,b2_b_fin_for_2080,b2_b_fin_for_2090,b2_b_fin_for _2100,b2_b_C_2010,b2_b_C_2020,b2_b_C_2030,b2_b_C_2040,b2_b_C_2050,b2_b _C_2060,b2_b_C_2070,b2_b_C_2080,b2_b_C_2090,b2_b_C_2100,b2_b_Bio4BE_20 10,b2_b_Bio4BE_2020,b2_b_Bio4BE_2030,b2_b_Bio4BE_2040,b2_b_Bio4BE_2050 ,b2_b_Bio4BE_2060,b2_b_Bio4BE_2070,b2_b_Bio4BE_2080,b2_b_Bio4BE_2090,b 2_b_Bio4BE_2100
20856,0.00041102,0.00079438,0.00084723,0.00089625,0.0016303,0.0029791, 0.0048498,0.007222,0.010121,0.013587,0,0,0,-0.0000579,-0.00016028,-0.0 0024903,-0.0002742,-0.00029353,-0.00030874,-0.00032472,0,0,0,0.5886062 55,1.494969129,3.700636979,5.787559712,8.833552699,13.12264937,17.6130 7984,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,159.4858796,198.9589632,2 79.0264541,388.8116698,684.6920801,1360.896218,1894.763627,2467.726899 ,1653.126701,2129.405581,141381,141381,141381,141381.5886,141383.0836, 141386.7842,141392.5718,141401.4053,141414.528,141432.1411,141221.5141 ,141022.5552,140743.5287,140354.717,139670.025,138309.1287,136414.3651 ,133946.6382,132293.5115,130164.1059,0.0009886,0.00085856,0.002836428, 0.013587389,0.05211431,0.131137717,0.216786731,0.313212255,0.210599293 ,0.26260431,0.000410385,0.000791622,0.000842001,0.00088735,0.001603334 ,0.002890788,0.004617943,0.006706896,0.009240585,0.012132373,0.0004016 7,0.0016042,0.0032963,0.0049699,0.0064285,0.0091407,0.013023,0.023004, 0.023091,0.028804,0.0036578,0.0039008,0.0054104,0.0068583,0.008391,0.0 092179,0.0095294,0.0083343,0.008833,0.0085091,0,0,0,0.132795953,0.3346 24306,0.754114488,1.100208271,1.409096928,1.773493457,2.650667545,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,33.75689194,39.04177382,57.5098305 7,79.47503202,141.2855288,274.5224754,384.5391422,481.3015705,318.2274 493,475.2449266,141381,141381,141381,141381.1328,141381.4674,141382.22 15,141383.3217,141384.7308,141386.5043,141389.155,141347.2431,141308.2 013,141250.6915,141171.2165,141029.9309,140755.4085,140370.8693,139889 .5678,139571.3403,139096.0954,-0.016931766,0.003302734,0.004532011,0.0 10469427,-0.003191946,-0.021209193,-0.091617996,-0.261663494,-0.386519 875,-1.961944899,0.000401539,0.001603069,0.003292139,0.004959801,0.006 406643,0.009085339,0.012895708,0.022672225,0.022687082,0.028168226,0,0 ,0,0,0,0,0,0,0,0,20.32540777,23.43689152,34.28329515,47.37756355,84.22 490911,163.6514817,229.2356719,286.9186708,189.7056272,283.3087631,141 296.4648,141192.8372,141045.8633,140841.4563,140480.7048,139767.4278,1 38772.9532,137489.3927,136632.0385,135488.7266,-0.009694255,0.00231560 4,0.003847215,0.01172868,0.01914463,0.04031926,0.032937636,-0.02948802 4,-0.14536094,-1.063514657,0.000405112,0.001275349,0.0023026,0.0033150 57,0.004466727,0.006583541,0.009552561,0.016224296,0.017256436,0.02169 1815
20857,0.00044355,0.0012275,0.0015562,0.0016392,0.0018507,0.0024266,0.0 035251,0.0048609,0.0070691,0.009751,0,0,0,-0.0000752,-0.00020633,-0.00 03201,-0.00035283,-0.00037815,-0.00039786,-0.00041849,0,0,0,0.72824257 3,1.83318955,4.531334853,7.094234187,10.84073756,16.10956533,21.623100 97,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,161.2538007,200.0891837,278 .7315285,385.9737226,680.5775473,1353.31892,1884.021278,2453.443583,16 43.416666,2116.861115,165997,165997,165997,165997.7282,165999.5614,166 004.0928,166011.187,166022.0277,166038.1373,166059.7604,165835.7462,16 5635.657,165356.9255,164970.9518,164290.3742,162937.0553,161053.034,15 8599.5904,156956.1738,154839.3127,0.000999559,0.000863437,0.00283343,0 .013468623,0.051744313,0.130304673,0.215420656,0.311216204,0.209126346 ,0.260773159,0.00044296,0.001223841,0.001547986,0.001625336,0.00182468 5,0.002365534,0.003382076,0.004566631,0.006547063,0.00886448,0.0001390 3,0.001228,0.0027809,0.0043361,0.0056439,0.0082232,0.012,0.022134,0.02 2012,0.027685,0.0038949,0.0041535,0.0057598,0.0072984,0.0089246,0.0098 018,0.010132,0.008867,0.0094382,0.0090904,0,0,0,0.164299421,0.41032939 7,0.923393805,1.348605546,1.729275922,2.177167729,3.254152736,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,34.13109135,39.26355732,57.44904377,78 .89494155,140.4364991,272.9939689,382.3590002,478.515775,316.3582642,4 72.445228,165997,165997,165997,165997.1643,165997.5746,165998.498,1659 99.8466,166001.5759,166003.7531,166007.0072,165962.8689,165923.6054,16 5866.1563,165787.2614,165646.8249,165373.8309,164991.4719,164512.9561, 164196.5979,163724.1526,-0.016922904,0.003552037,0.00488234,0.01088262 3,-0.002586381,-0.02044876,-0.090417143,-0.259499836,-0.383401807,-1.9 48804161,0.000138991,0.001227256,0.002777898,0.004328597,0.005627597,0 .008180941,0.011900536,0.021863378,0.021685614,0.02716705,0,0,0,0,0,0, 0,0,0,0,20.34655984,23.40617563,34.24708559,47.03238884,83.71959346,16 2.7416416,227.9380053,285.2603472,188.5939629,281.6426215,165911.5278, 165807.3116,165660.4931,165457.5783,165098.9949,164389.6898,163400.854 1,162124.7238,161272.4062,160135.8303,-0.009684555,0.002466192,0.00405 4846,0.011927031,0.019356169,0.040436063,0.033101637,-0.029004621,-0.1 44097329,-1.056421674,0.000261755,0.001225877,0.002281173,0.00323683,0 .004091714,0.005832271,0.008460184,0.014877737,0.015571604,0.019775187
20858,0.00073346,0.0016116,0.0022754,0.0027148,0.0029167,0.0033832,0.0 041853,0.0049943,0.0061708,0.0079054,0,0,0,-0.00015533,-0.00041117,-0. 00062968,-0.00069219,-0.00074092,-0.0007792,-0.00081912,0,0,0,1.503938 156,3.653224322,8.913839419,13.9178303,21.24078386,31.55004171,42.3243 5045,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,155.0424548,191.8039876,2 66.1748465,367.2690704,648.089647,1289.012466,1794.408287,2336.620665, 1565.056409,2015.87466,154456,154456,154456,154457.5039,154461.1572,15 4470.071,154483.9888,154505.2296,154536.7797,154579.104,154300.9575,15 4109.1536,153842.9787,153475.7096,152827.62,151538.6075,149744.1992,14 7407.5786,145842.5222,143826.6475,0.000961057,0.000827685,0.002705786, 0.012721614,0.049005659,0.123623774,0.204514323,0.295502974,0.19798752 1,0.246916625,0.000732452,0.001606645,0.002263038,0.002691225,0.002874 659,0.003295969,0.004011395,0.004684756,0.005704317,0.007169774,0.0003 0294,0.00084733,0.0021709,0.0033826,0.0044437,0.0067029,0.010101,0.019 662,0.019335,0.024562,0.0037473,0.0039961,0.0055409,0.0070196,0.008581 ,0.0094231,0.0097401,0.0085271,0.0090509,0.0087163,0,0,0,0.339304755,0 .817714314,1.816459027,2.645763113,3.388254341,4.263909747,6.369572107 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,32.81639357,37.63775094,54.86 100009,75.07161795,133.7326532,260.0219534,364.172192,455.730817,301.2 738883,449.9068723,154456,154456,154456,154456.3393,154457.157,154458. 9735,154461.6192,154465.0075,154469.2714,154475.641,154423.1836,154385 .5459,154330.6849,154255.6132,154121.8806,153861.8586,153497.6864,1530 41.9556,152740.6817,152290.7749,-0.016268621,0.003419542,0.004702969,0 .010427051,-0.002367538,-0.019351578,-0.085893871,-0.246699522,-0.3640 49337,-1.850749429,0
sorry, so viel info hätts nicht werden sollen!tut mir leid!:)

excel schaffts nicht, die daten als txt abzuspeichern , nehm an, es sind zu viele....was muss man da tun?

vielen lieben dank,
roberto
Wo ist das Problem? Hat (auch) Excel die Spalten nicht trennen können?
Das liegt daran, das diese CSV-Datei im englischen Stile formatiert ist,
d.h. Dezimalpunkt und Komma zur Spaltentrennung.
Stelle einfach Dein System während des Importes auf en(en): Systemsteuerung -> Regions- und Sprachoptionen.

Dann Excel die Datei lesen und als DBF-III abspeichern.
Die DBF ist dann unabhängig von der Systemeinstellung. -- Klaus
Ja ... oder einfach die Dateierweiterung *.csv in *.txt umändern und als Tabelle ins AV laden.
Passt bei deinen Daten einwandfrei :)
Man lernt doch immer noch dazu. Demnächst wieder 4 Clicks gespart :-)
danke euch! mit dem einfach umbenennen erspart man sich einiges! das eigentliche problem ist aber dieses:

ich hab eben nur diesen table, kann ihn in arc view nirgends dazu hängen - kann ich ihn nicht auch so visualisieren, ohne ihn in ein aktives thema zu joinen?

danke und liebe grüße,
roberto
noch was: die dateien sind auf grids aufgebaut - die informationen sind pro Gridnummer. es sind also für jedes grid keine eindeutigen x und y vorhanden, sondern nur die nummer des grids.es gibt kein grid zum dranhängen, das diese gridnummern hat.....

danke!
Was du also zur Verortung der Tabelle bräuchtest sind folgende Informationen über das nichtvorhandene Grid:

- Zahl der Reihen und Spalten
- Zellgröße
- zumindest eine Koordinate (z.B. Grid-Ursprung o.ä.)
das erinnert mich stark ans ASCII-Format, kann das sein?

kann ich das auch selbst schreiben? was muss ich da beachten?

danke für die infos, ihr seid einfach klasse!!!

lg, roberto
Nein, eigentlich meinte ich keinen ASCII-Header.
Aber aus den von mir genannten Angaben könnte man ein
passendes Raster aus Punkten erzeugen und dann versuchen,
deine Tabelle dranzuhängen.