وارد کردن فایل اکسل از طریق سی شارپ در دیتابیس اکسس

[jmfnima]

با سلام به همه دوستان
من یک فایل اکسل با 5 ستون دارم که میخوام این فایل رو از طریق سی شارپ به صورت یکجا به داخل یک جدول در دیتابیس اکسس وارد کنم . از دوستان میخوام هر کس میتونه به من کمک کنه . ممنون

[hakim22]

شک دارم تابعی باشه که مستقیما رکوردها رو مثل خود نرم افزار Access منتقل کنه ، ولی میتونید این کارو با یک حلقه انجام بدید . cell های اکسل رو به صورت record به دیتابیس یکی یکی add کنید !

[tooraj_azizi_1035]

Easy:


http://www.mikesdotnetting.com/images/excel1.gif
http://barnamenevis.org/image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAfYAAAC7CAIAAAA YOCvtAAAgAElEQVR4nO2d64/b1pnG9afk02Q/riD0iwsMoEWwQIACGzsJsHXoQshM3doO4KSOGwycRQV72BZIs7 ltmgQYT1VfqhZIMnXjjh3UDBzYFhAvMuPUsVVtYnu3iseXxDNN Smus3rQfDnn4nsNzOJTEm8TnxQNDOkMekg9f/vjykBYLPzh245tP/+LqzXtXb/8dgiAIGicVNm3dXz/ZbN38GwRBEDRmKmzaur+50oUgCILGT0A8BEHQ2AqIhyAIGlsB8 RAEQWOrwqat+5eurEMQBEHjpyDEz7zwO64d5ntMlX1v6ZT6xkA QBEFUGyD+t2euclX2vfX2qf/hqux7q36yyfXNp3+R+sZAEARBVBsgPqBmr+x765tP/4Iq9Y2BIAiCqIIQf/Q353okfr5wbn29x7Sy1p178/0vO90vO92VL/+xdGX9aw9O0XmX/++jV56c2fHkzI4nZ3btmTty6S+pbyoEQVDeNAjiV9a6HPHNle7 SlfXj5++qEP8yI/v7b720w3zv7Gfd1LcWgiAoVwp6aPLob84x/XxB0Nyb70t69ci7X3twSpz9IkO8/Pna50d/5JX2/K+HTr/3H0/OsDPBxdO/5OX/4gqbpntizrkmYNPIMz458/LZv7IplbNDEATlUEGI//mCV8WvrwsDNVdv3pt78/2VL//BxKp4cXY14k/MzeyYu9hc6V68+N7MC787+xn7qwDul5/8lYRmfh1Ae6AzXjz9SxfoitkhCILyqVCIZ1hniF9Z6169ec9B/Fq38Yf1xh/WgxFPAC2X80cu/UU8GXR9X/0tHOLKs4h/dgiCoJwqCPFzb76/4fgMlwrxM74BE6+RjNUomU7HXqTCXElz6bMwdANBEJRPFTZt3a/7Fcq5N9/nAzVfdrxHaNhd1lePvMvuu66sdVkVT+dlzD16+a+DNdJ2aQKpi mft/k503UIQBOVHQYh/9ci7fJTmzlcdhvirN+81V7pLV9YZ4tlAza+X18MgvnXzb2wkPc yU1/548+iPZl4++1dnLvO9s591aQ/BiKezQxAE5VOFTVv3S28J4X979ci7/KEa/8iMpJCIF8ZqyAA9LdL5BD84doPPKD1R09IgXjc7BEFQDqVAPBc Dd3il/gorCIIgiKqwaev+/73zdwiCIGj8BMRDEASNrYB4CIKgsRUQD0EQNLYqbNq6n/8OAQRBEDROAuIhCILGVh7iP7UhCIKgsVJh09b9v15ehyAIgsZP hU1b9/Mfj4QgCILGSYVNW/f/9szVxh/Wf/3fa0yXPvuqX7HTRbc5B/k1v7jEf2cfooIzcAbOxKQLzevsgxrxvzp7qy8B8cGI76zfg/yCM3AGzsSkWBB/79KrkF/zi0v8R5ghKjgDZ+BMTIoF8esX/xPyC0mpE5yBM3AmJgHxQHz6yo4zt079cGL68Mf2vdTXJGvOZE0 DO6PbxVnb9UodNycfOXq1rzWPBvHnmqsC4j96Llg9a8eW8uT95 cn7y5MT2x77ZKPplfrkpW9MzOwZcq5Teyf514PbnFVievbo7AB rFaD5xaU7X3WUOm4Ki/7+qbuske053VxUF498e+KAJXX4yNGrugkyJcmZW6d+KFmRmPjR khEPA3JmeLENTNjhuJ25eOTbwRul24nK9uPm5ER56vWW0EJTYn j/aarfuHRki37lb61++sq04q/BaRkB4s81Vzvr98Ij/u7hRybKm+dP/Zgz99EXZlJHfGd55uC2Sb4mdw8/cn95crAVGwzxQ+bNhcPTEuIf3j49UZ49vnpXOUGmRJ2hWX7jzu mnpg8trybHIIZ4tsQseBgf4m/cOf298tQzZnazYgBnWPJIJ2ZJumPN335r9dM3tm9/xpzm7TfunN4b0UlRx+sNdxk93wRvEdOwiGd8lxDfWZ7VaumJve XJZ48q/zrD6+iJ8uZTpHHfoWf2uu3zp35Mp2Qg7izP2ie2bSEFOOuTNu4 79Ix/LoZ4viDWyMRORacCtqVPzS8u8ZfcSmI7yd84ccBaWeuyXfvaoR/eX55kxLlweNo1auq/Lt95ZdrbLtbPcXPy4UOnX5l2elhZ6zI8sc/8SGC1w8pal2Xza5dPuz7PHl/9lHU7UZ569ZLNZrzlNvI10W1RX6LO3Lh0ZDNZIpdu0cpt8U/pHlF8A71F8B4mylOvHXIQH5+HAzsTrdjJrNGubxb3I72Eur/sbHtM+z2qnOFihww/cLi848U8wsAa3O7s4junnyrPLvz+sGHUWEpIyUkPw1cv2ZzadG U8t0Xf2EEtZcWNS0f47pA61/5VtebCtg+D+HPNVT7iExLx9oltj5Yf9nPz7odPH9w2OfH977Cv n7z0DYZXp90h++ypveI07ufO0hPPfuvxTz56zmnf9tgnHz3HTi cOtd0JhLlIh2xBFPGBZyNBPX1Ehfi95NCie5rr/M+maVqzDmlG8gl4aew0Th9eXr3LspMtgh/PLG/4NFLW0nadApzRHa7umsjZr1w0c4ZZx7brwzufUCif/9k03SjeLe+NtfMe9pYn6cZG6+GQzkQrtnV08yXu0Izqd78Po4G d4RiV1pDngLMhdANV7UKH04c/vPPJG9u3sz/xizzF7AcsIZcuHdki5pJ01vFDn3rr7zzor4EFxOCIP9dcpZcDI uJndCKlsdBO0D/TWZ7pLD2xr/zQ/KkfM/I+e3TWm33bY60P9nSWZ1rPPzjx/e/4F8G7Ui5LmstF/AxB/AxfBxfx2s3h6vV6j03temxq17/+27/fX/z6/cWv93o9aZr5xaWVW3eUevsAqZvKswtf3GWNEweslVt3+OUhm5g PZdAenAOSdPjQwctOJ9OHz9/6UpqAd7W5PLvwxd3rn7ecWsDXG8vFhS/uerBj83IcaDaKSemMNI3fGWbIhNu/btF83fxbJE0pbSA7Vs/f+lKanrfH4WEkzkQi6icDB9tk6oZoUd/7fRgN4Awzn+0vmhXSseNtlKad9sn3oP8DnZ0umubMllnTMGp+A 3nn0kA8nz248zBrTjUg4s81V6WO+kP8+WeC2+0P9rDxGf5hQ8S 3nn+QUHLzqfPP0Ik3RDxbkB/xfNFhKM/S8b5/+mc/3zdEPNuLUiPLp2sr1t7y5FOLa/QQZaMEfC4d4tm8Dx28TCeg6TVRnn1z5U8sk/gihN7emWXT0KEJfgn54vKfwhyx1Bn/BDpnzv9smi1Cu+h3ZuX8dteWHvlPLa5JG+jNKE5PO4zcwwidGV I+rDv78dqK9T33s1dhDLrfh1G/zui2iH6mO0XXTsUTgJ353lz5k3ecvjNLDZEOQ+dM+fvDfK6Azr m8/FF1zv8aZs2pBkG8tXzT3xFFvP3BngAxbsrtrPQ+77XvKz90cHF PZ+kJznr7gz2c2vYHexisvfbyZmd2tyuh0RWdy/5gD0M8+3xw2+SjP/ku/5Ny9mD1ej2Wkcq/zi8uXbm+phTb3/7GiQPWletrHPHSBLSd7Wl1h4uzE+XZl+annAkWHahdub52bfnQ ZufzZZZAbBahN3d6MrF6KwLEnVH+Ve+Ms1baRZNtcTwRp+TMkj bwyqKDcrlntz0ODyN1ZhhdpjdvOEfYtmwRz1t+SxNTeGfYgSBt kbMj6J5yT9VB7b7cY1/fPjBp1GrC4ebmCRVrn5v9l4cOXma599LJQ5udDNR2LuWqsnMvk zdec0F9I95avnntjwqFR3zr+QcnypsPLnpfH/3Jd/98bicbi/em2fZY64M9rF2LePczxfGpvU4V/9WZx/eWPWo/+63HW+JcQYg/sW1LWSB+eMrr/hQ54mminJmbmpg+fFbdoXNI+/H09gF+JAs5d2Zuyo94Nk1wPgUfsbo/UWfOzE2JYPUA7V80TfFrKxYdi/c2xLFFgfizUg/Lh9j46dl4PBzSmcjkuUpWlW3C4iwtFOi2D7zfh1FIZ/iR4l/ha8ucsM4eZDtI1+6llu/cT097/tpCNZnTsyJvlxXc95ao6pz/dcM1l9Qf4nV87wvxjM7eRZ8LXEZkqZGO2EiI50/LMBCf2us+KvOT7+4rP8Qrel6VOCcV31wU8bQK4CehqBQZ4he96 zie2bz+Yv1IHTrwcifmQ/9GrfZUH4hfkwpAelIZRqIz3iJEEqkXzTecT0xrOrKGasSLPTiP T6gQH4GHQzsTjXxAFBJMuC0kuhf5fo8qZyZ8uKTbyO/rvHb59FMEnbp2f4Zwi6QqSroG4knifr38yrTGKxXEaZXm79z/V+2ai+oD8QF8lxD/53M7Ib/iuegeB8GZjDgTeC2YLSFnQios4q3lm5evXgkQEB8G8c1rn0N+w ZmMOMOKX+frykU23JG6CVlwZnQVy2/UfHXmccgvJKVOcCYrzqxcpAMymeV7Cs6MrID4RBF/6cptyC84A2fgTEwKQvzALwlMHabZFJJSJzgDZ+BMTIoe8T1rBx SgC83rkKT5xaXU1yGbgjNwZnix35hRIL536flBZO0I+JWJXIe1 o2ftiOmXPUZaF5rXU1+HbArOwJnhjWL4AeKjjIIvej0gPigLU1 +HbArOwJnhjXKgBMRHGEB8v1mY+jpkU3AGzgxvlAMlID7CAOL7 zcLU1yGbgjNwZnijHCgB8REGEN9vFqa+DtkUnIEzwxvlQAmIjz AiR/z1z1svlAs7j6X/tp2YsjCBpdw+trtQ/ml877IYXWdGUXAmvFEOlID4CKNQKExMH+71eiem7lMiniG7UJC pffvY7kKhwEm0sMv5nB/Ec2fc2L3whXqruTkhlwLEj4oWdhUKhUL5xeaKPx92ncyzMwMIi I8jGs/1egu7Hpg6sQHit5QnJegs7CrseHLGT6K8IV44vN2jekgB8SOh2 8d2F8q7d4o54M/8HDozmID4WKJQKBQK922I+J3HTu4sPPDCspO+t5d/Wi7sPri4R6jid52UEv32sd0Fdy6xxtEWvBmXDvEra90PX3zAcW P1+M7CAy/NT/Et9Zlzcqfjg2Sp0/jS/BQQn3GxXVmpt18A4iMSEB9LhEb83YVdIs52naTFph/xlO90ghVKw7SzaoAs5J/9Vbzjz+rxneJpTDKH2yK1C7OPmj95Axk7BBRXcr6Td96cGVhAf CwRHvG3j+12sLV6nFX0AYjftWeuLJeo3lfeQ+pZNUAW8s++sXh 3i1aP7xRvXSgvcVbIgAy7KuKnBAzUZFx8f0lXclwfvvgAP8fny plhBMTHEuERz8nlgUmPeP0ohKLMGSEFDNR4Vy0DIJ6fPsX21Ld 3MGfGW3Qn6hBPcyA/zgwpID6W6APx7sUpH7EJHqihozFSlTq6CkC8d1Sjih9vOQNxYo j7i1625siZ4QTExxJ9Id4txh0YBSOePmSiLXZGTTFV8WwW58TJ TAbiR0E0BxZ2iXee3D2YT2cGEBAfRzSeE7+fmLqv19MiXno0MB jxK2tdSi555HrUEMazkH/2jcULW90f4oWxrN0Lvz+8uTw7Wv7kE2QU8c7/FPGldz6dGUBAfCzhv+Ls9fADBkFZmPo6ZFNwBs4Mb5QDJSA+wg Di+83C1Nchm4IzcGZ4oxwoAfERBhDfbxamvg7ZFJyBM8Mb5UAJ iI8wgPh+szD1dcim4AycGd4oB0p+xM8vLg2g1F+OmnGl/iJHCIJyJe27Wwc7aaTO0Iyrs34PknSheT31dcim4AycGd4obRU/GOLnF5dS36psCkkJZ+AMnEneKCA+Oa9TX4dsCs7AGTgTn1FAfH Jep74O2RScgTNwJj6jgPjkvE59HbIpOANn4Ex8RgHxyXkdR7e2 VS0atY/t9DcwbmesarFYtVJf2ww6k0PBmfBGAfHRq1UzSm5ULZt7Taexq sUSCT5ZvxozxNt2q2ZQZ0zLtrljQHwexA4No9ZiX8nR5CVDPp0 ZQEB89Oo25wyXua2awfPSj3iexMNoLBHPnGGfOdaB+DzItqpFo 1r1csCquulNEyCHzgwmID5edZtzRtF4vdXphEC8zWhdq/KCRSxpvRKm25wzisVSqVQsGrXa2CK+s36PffEf4TpnbKtKr43Y 9MpGXhsW3R2UQeUNZGy3Vi0hB7hoMuTNmYEFxMcr26qGr+Jt2z L1QxM8v8U61zJLpXFFvIR77oZU3fNLJXaOZLxmqOi4J06psduc M4pV7nNmlTeQsR0k7Xcmluq8MW/ODCwgPkZJmRo4Fu8QyiSD8vQKoENQJeFpLAdqvIqbOMARLzugc obbom8sDnz/IxVnxl58T0kHDr8Io8N0uXJmGAHxMcqqFil8Q1bxIuKFW7KMd/TKoDOmiKeHN6e8V8VLDthu8UcKdlLyKxqpvZHcEUnAmfEW34kd Xw5wBdzZgnQC4uOSxPfOgIhXDCbkoYr3EE88CVfFywP0ykad51 lTfkDmjlIKISV2wJ0tSCcgPno5I8U+7PaLeF0tQwclGb/GGfHKKt43Fu/cpbCq/kdulI3S4oD4TInmQLc5Z/huuuTWmQEExEcv6fkNPobYL+I7/oFpF+WkMjWtVs0YO8RT97gh4hM1XtFHz3D0Dgd9FEdqpPsoyw9 i5hNk/lvu/hsz+XRmAAHxiXqd+jpkU1E5Qx+q67gnUWVj6pucsDPjJzgT3ig gPjmvU1+HbCoqZ/wPzhu1lrIx9U1O2JnxE5wJbxQQn5zXqa9DNhWVM9Igj/9KP+PPz8TnzPgJzoQ3CohPzuvU1yGbgjNwBs7EZ1TE726dX1xK 5oWEEARB0IaK+N2t84tLPYQqLrinU4QUcEYXcEYXcCZkXIhjoC bdTcpsICl1AWd0AWd0AWdCBhCfXCApdQFndAFndAFnQgYQn1wg KXUBZ3QBZ3QBZ0IGEJ9cICl1AWd0AWd0AWdCBhCfXCApdQFndA FndAFnQgYQH0u06xX+04YNt1FMyna9Qv6W76DO1CvUs17DLOXZ pryBjBw4ZLerDqe8OTNwAPFxRKNq1NrsEyEUEK8LwZmGWSpV6s y+dr3CP+cy8gWydt1wD5y2d6onCUE+5suZIQKIjzcoozZGvKJa ESdrmCTZK/W66U2rvHAYkZAOV35eFEt4ZYWn84e1N9xfoyTniYb4s+TZNiu/IONHjpAE3u7OrzN9BhAfa9CKdEPEe7U/OTEEIJ7ySTnvyIR8uLKNFrakTQdwyJcgxAvFnzORfBKId8OGjv yCzN1nYj573/LrTJ8BxMcTvFQkEOljoMb7YxDi1bOPBLrE8B+uDTOoWCdGBFfx gZN7E2c38goyD+VSycJ3Wl6d6TuA+HiDFp8bIp6ORGxUpcqIV8 07MqE4XCV7VJvLx6f6QHyok2SGIp8g09+OQRXfdwDxMQfJ0A0Q T5HTbxWvnndkYmPER1nFj9KJMIcgEwY3exiLHzaA+BiiXTeqlv sxdBUvDhgLnz3aq4aX9fOOSmyMeP9YvEsBjT8axDfM0fImZyBr 1ysl3+iZlNzKowmhDSA+jqC1opewfsSTqNTb3gB+pV4nKCLj+v phBs28oxEhEN8THoURKKD0R1fdiw/UYCw+UyE97FQST95BRxNCG0B8coGk1EVizuju3WU2kDO6gDMhA 4hPLpCUukjMGf+D9kD8iAacCRlAfHKBpNRFgs4I42MZ53sPOaM POBMygPjkAkmpCzijCzijCzgTMoIQj3e3QhAEjbqif3dr6i8dz 6Yu4J3xcAbOwJnEjdJW8UB85F6nvg7ZFJyBM3AmPqOA+OS8Tn0 dsik4A2fgTHxGAfHJeZ36OmRTcAbOwJn4jALik/M69XXIpuAMnIEz8RkFxCfndWLLsq1q0ah9bKe/1XE7Y1WLxarl/zweAsjgzPBGAfFxyaoWS6WSUWtxr/mfbLtVM4qlUqlq2XQW26qWSqXh6TzSiGe+8ZAs8psMxI+NWjXD v9+VjXlzZmAB8XHJtqpFo1o1igGIf3j7tARiq1o0TROI56ZtKC B+bNRtzhlu0rZqRqlkWratbMybM8MIiI9FjOBVq1ULRLzZaFSL xuutDmvsNueMYrXR8BDfbc4ZxSKtX/iM7Ef5ivLsRdZYqzmIp9Rj84anZ2IKg3h+3cN+gZAd5x094pXT s73iTGBVebttW6brMK8ZqbcZcSY/6jbnDJ//tDG3zvQrID4WMZRISPUjvmrZFGe06WP7nm1bVVK/uI2tmlHk9OFQo8tiwHKmJyBTHjZZUBjEU3xzNzoaxDsukem9kr BYZW5cfmu2UnGwztvpBFlQbkFG81bZmFtn+hUQH704JsIgnmet bVusoleOsUh98hFJPrHEJnqeoPVpNscxAsfiOZq9kxP3qqNBvO wG99Z1w7ZbNaPaaJhs73Bn2JVQ8Oh/is7kRMrLzYCjCQoQEB+xKIJDIZ5Dh0OZIJ7eaHLPBGrES1WP1A m/pMgOvKg2rOLpgJU0iqKu4iU3yLazzm3bMs0GG+dtic7wZWVhRC ufILOqRX+VIzXm05kBBMRHLIZsKYpGraNBfMdFMOeaktoDV/HevC7pU7fIr3CIV698X1U8d+bK4qxRa9l2643t2+vthukfEyBX P9lxJg8Kw/d8OjOYgPgYFaaK73hlo3vrT4V4q1rcoIq3LdMtPFmH/JDgNx6zOUrTCYH4gBvFIcfiiRtWtWiYZoUX9aZp+p3JyEVPrkD m7DUR5crGvDkzjID4GBUS8RKPaAHOR6WNWs0MRHxHGM0wrVbNI EcFG/BJHVg69f9ETakYeLu1I15O+Z9MpSdU6gz76syVgTNirkBGzee7 QNmYN2eGERCfqNdpLVr5fEJ2hMMVzsCZ+IwC4pPzOq1FZ/z/BOFwhTNwJj6jgPjkvE5luRm5c5hBZ7IvOANnhjcKiE/O69TXIZuCM3AGzsRnFN7dCkEQNLaK/t2t/b8lPBdxAe+M1wSc0QWc0QWcCRkX4hioSXeTMhtISl3AGV3AGV3 AmZABxCcXSEpdwBldwBldwJmQAcQnF0hKXcAZXcAZXcCZkAHEJ xdISl3AGV3AGV3AmZABxCcX4ZOyYZZKZiPWlclURH64EgPb9co IewmQ6QLOhAwgPo5o1yv0N4AdwCiTkr29SWJQzhHfEH+rcwAng PjRDXLwVOrtXq9HE8JtyaUzgwUQH0eosaJKyoZZqpimPDUQ7x3 KAwUQP6LRrlfkfd8wRdY7OzNvzgwcQHwcERrxDbNUqd+4dESaX EA8qWrcNtY/r22G5GH6EQrxWh8Us6kR78EiwEB6Bcb7bpilSr1uDnpRMXjkDG SKPS9C35sgZ84MHkB8HEExEXRp6SasXLsQQjWqRq3NO3UmYv07 X8ag5A+BeK0PYRFPi0G9gfQzWZByOC2JyBfI2vVKqVKRzuRCfn tf8uXMEAHExxvtekV7aSmxilBNTW0PaFq0jWgEjsX7jAjhg4z4 unQO1cyoONWyr6mdRvMFMnoaJkcOyYdKpQLE9xdAfNyhrTsEnv guR4VaUubd+CPev0F9+SAhXjkao0G8FEB8guEboPRfzKGK7zeA +JiDJKqYlFqc9Ggiy7DPK+L79ME/UCMCIwDxSpID8YlEQNXDArdb+w8gPvo4Mzcl1ONungpJKQwN93 rikI4S8Q0zx1W82gfSLIyuK2+3UoN1Biorxx4Qn1RItz8Cnq3J mzODBxAfQ9CxZJKlNClVzFDX7uSxj7qZW8SrfaDNZmPDJ2o8Rg QYKF5dpX1LO3cg8z83pXhOvtfLoTODBhCfXCApdQFndAFndAFn QgYQn1wgKXUBZ3QBZ3QBZ0IGEJ9cICl1AWd0AWd0AWdCBhCfXC ApdQFndAFndAFnQkYQ4vHuVgiCoFFX9O9uTf2l49nUBbwzHs7A GTiTuFHaKh6Ij9zr1Nchm4IzcAbOxGcUEJ+c16mvQzYFZ+AMnI nPKCA+Oa9TX4dsCs7AGTgTn1FAfHJep74O2RScgTNwJj6jgPjk vI6qK9uqFo3ax3Zk6xZ5h2k5k4wSs2vknElMcCa8UUB8LGrVDP bDGsWi8Xqr0xGT0rZbNaNIfx3Xsu3wnY834q0qdaZUtfpwJhkB 8fEZy/e7UWsFNObNmYEFxMeiVs3wI8CPeJ6vVrVYrFrh+x97xHNnsikg PhZXbavq1kPd5pxRNF5vdZSNeXNmGAHx0YsmpeQ1mUZAPEcGa+ d1K0VJtzlnFIvssqBWc9rpuYH2ySfmVTBbq1qtyi8alB2m4lgY xIfYotYb27fX295vT1rupRK/kBo5u3IFsm5zzihW2eUsP4iUjXlzZhgB8dGL1Rr8FZScKTrEs8 9sMh3ixekts1Ry2q0qH+QRCh8XQPx6gs3FJ9Z1mIpjGyI+/Baxr3wcjDnpzTJqduUNZFa1yM/N9BrX35g3ZwYWEB+9bKtaFC4tHWQHjMV75bwG8bSW6Qjot0wKM t9oD5+RTtlZ13aYimOBY/HyXQrdFknWUTc42UfOrhyCjO19yV5/Yw6dGUxAfPSipSKt/rRVvG96RRVPpumIiHFm8AFOoqQMRH2HySvMQM3GWxQC8SNnV65 AJp+A3Wssf2PenBlGQHz0ojeFQiHe9zl8Fd/hBaaLrs66fzgiQ2WpUhsP1ITYopCIHy27cgUy+pACPyiUjXlzZ hgB8dFLqtADHpoUHwtzKMNvCbJBHjogQ+8NSnlPB/2l3jQ1r7bD5NUX4vVbFArxo2VXrkDmO9cWq5atbMybM8MIiI9F/ic0OsGIJ0Bxb/SV2PtI/U/UlEqm1aoZBDFsnIE+P86Hs41azVQxK7jDhBVmoGbDLQqJ+NGyK 28go7dhxNutcmPenBlYQHyiXsfUs4SwkVPCh+sI2QWQwZnhjQL ik/M6pp77/Z9TWVPCh+sI2QWQwZnhjQLik/M6jm79QwojpyQP19GyCyCDM8MbBcQn53Xq65BNwRk4A2fiMwrv boUgCBpbRf/u1v7fEp6LuIB3xmsCzugCzugCzoSMC3EM1KS7SZkNJKUu4Iwu4 Iwu4EzIAOKTCySlLuCMLuCMLuBMyADikwskpS7gjC7gjC7gTMg A4pMLJKUu4Iwu4Iwu4EzIGBDxhUJh1BHfrlcq9XacS2iYJWEJS EpdwNIPbb8AAAHiSURBVBldwBldwJmQ0R/iOdn9H0YN8QJ/2YuCKI/b9UrJbAy5DOksgqTUBZzRBZzp9djRyH+2yWmDMyGj7yqeMZ3+O 5KIFyvshll6bGoXyZ9oEC8tBUmpCzijCzjDCjDnMCIf4UzIGGS gpuDG6A7UNEzK817DLD186HS94jWKiCdVhNsqTCB0R78IjEdS6 gLO6ALOiAeXd9jBmZDRB+IL+hg1xLfrFWFYxiExaaYEpznmTUK mWHlntlJRsl/4gqTUBZzRBZwRj1XvG5wJGfms4qUi3iu2+YWgx2bN6YB00q4Z1 UbD9JFfmLqHpNQHnNEFnJGOP35AwZmQkc+xeC3iOeRFxEvhDQx W6u1er2GajV67bhi1lt2SxvCB+DABZ3QBZ1DFDxn5fKImAPHOH +sC4jU3XtlsTv3efmP79nq7YYoTA/FhAs7oAs5gLH7IyOdz8drBF/5X6caq5gn6hlmqmGaFTdgwS6YpER5j8aECzugCzgiMJx/hTMjI6f9u9T9RI0CcQV79RE1JGhkUHp8pSQU/nqgJFXBGF3Cm16PHH46mviOniPdBPbalEOYjKXUBZ3QBZ3QBZ0 JGXhGfCOOlawUkpS7gjC7gjC7gTMjILeLxGzUZCjijCzijCzgT MrhR/w8t/MyRG9PhzgAAAABJRU5ErkJggg==

http://www.mikesdotnetting.com/images/Excel2.gif

http://www.mikesdotnetting.com/images/excel3.gif


string Access = Server.MapPath("App_Data/contacts.mdb");
string Excel = Server.MapPath("App_Data/Book1.xls");
string connect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Excel +";Extended Properties=Excel 8.0;";
using (OleDbConnection conn = new OleDbConnection(connect))
{
using (OleDbCommand cmd = new OleDbCommand())
{
cmd.Connection = conn;
cmd.CommandText = "INSERT INTO [MS Access;Database=" + Access + "].[Persons] SELECT * FROM [Sheet1$]";
conn.Open();
cmd.ExecuteNonQuery();
}
}

[jmfnima]

با سلام و تشکر از شما دوست عزیز
من کدهای بالا رو به کار گرفتم ولی فقط برای اکسل 2003 کار میکنه و برای وارد کردن فایل اکسل 2007 و 2010 خطا میده میخواستم اگه کمکم کنین این مشکل من رفع بشه .
سوال دیگه ای که دارم اینه که اگه خواسته باشیم قبل از ذخیره اطلاعات فایل اکسل در دیتابیس ، اطلاعات رو توی یک دیتاتیبل بریزیم چیکار باید کرد ؟

[jmfnima]

با سلام به همه دوستان
کسی نیست که این مشکل منو رفع کنه ؟

[Yanehsar]

با سلام و تشکر از شما دوست عزیز
من کدهای بالا رو به کار گرفتم ولی فقط برای اکسل 2003 کار میکنه و برای وارد کردن فایل اکسل 2007 و 2010 خطا میده میخواستم اگه کمکم کنین این مشکل من رفع بشه .
سوال دیگه ای که دارم اینه که اگه خواسته باشیم قبل از ذخیره اطلاعات فایل اکسل در دیتابیس ، اطلاعات رو توی یک دیتاتیبل بریزیم چیکار باید کرد ؟

به نظرم مشكل از رشته اتصال باشه :
string connect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Excel +";Extended Properties=Excel 8.0;";


به اين تغيير بده امتحان كن

Provider=Microsoft.ACE.OLEDB.12.0 ...

[momimomi]

Easy:


http://www.mikesdotnetting.com/images/excel1.gif
http://barnamenevis.org/image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAfYAAAC7CAIAAAA YOCvtAAAgAElEQVR4nO2d64/b1pnG9afk02Q/riD0iwsMoEWwQIACGzsJsHXoQshM3doO4KSOGwycRQV72BZIs7 ltmgQYT1VfqhZIMnXjjh3UDBzYFhAvMuPUsVVtYnu3iseXxDNN Smus3rQfDnn4nsNzOJTEm8TnxQNDOkMekg9f/vjykBYLPzh245tP/+LqzXtXb/8dgiAIGicVNm3dXz/ZbN38GwRBEDRmKmzaur+50oUgCILGT0A8BEHQ2AqIhyAIGlsB8 RAEQWOrwqat+5eurEMQBEHjpyDEz7zwO64d5ntMlX1v6ZT6xkA QBEFUGyD+t2euclX2vfX2qf/hqux7q36yyfXNp3+R+sZAEARBVBsgPqBmr+x765tP/4Iq9Y2BIAiCqIIQf/Q353okfr5wbn29x7Sy1p178/0vO90vO92VL/+xdGX9aw9O0XmX/++jV56c2fHkzI4nZ3btmTty6S+pbyoEQVDeNAjiV9a6HPHNle7 SlfXj5++qEP8yI/v7b720w3zv7Gfd1LcWgiAoVwp6aPLob84x/XxB0Nyb70t69ci7X3twSpz9IkO8/Pna50d/5JX2/K+HTr/3H0/OsDPBxdO/5OX/4gqbpntizrkmYNPIMz458/LZv7IplbNDEATlUEGI//mCV8WvrwsDNVdv3pt78/2VL//BxKp4cXY14k/MzeyYu9hc6V68+N7MC787+xn7qwDul5/8lYRmfh1Ae6AzXjz9SxfoitkhCILyqVCIZ1hniF9Z6169ec9B/Fq38Yf1xh/WgxFPAC2X80cu/UU8GXR9X/0tHOLKs4h/dgiCoJwqCPFzb76/4fgMlwrxM74BE6+RjNUomU7HXqTCXElz6bMwdANBEJRPFTZt3a/7Fcq5N9/nAzVfdrxHaNhd1lePvMvuu66sdVkVT+dlzD16+a+DNdJ2aQKpi mft/k503UIQBOVHQYh/9ci7fJTmzlcdhvirN+81V7pLV9YZ4tlAza+X18MgvnXzb2wkPc yU1/548+iPZl4++1dnLvO9s591aQ/BiKezQxAE5VOFTVv3S28J4X979ci7/KEa/8iMpJCIF8ZqyAA9LdL5BD84doPPKD1R09IgXjc7BEFQDqVAPBc Dd3il/gorCIIgiKqwaev+/73zdwiCIGj8BMRDEASNrYB4CIKgsRUQD0EQNLYqbNq6n/8OAQRBEDROAuIhCILGVh7iP7UhCIKgsVJh09b9v15ehyAIgsZP hU1b9/Mfj4QgCILGSYVNW/f/9szVxh/Wf/3fa0yXPvuqX7HTRbc5B/k1v7jEf2cfooIzcAbOxKQLzevsgxrxvzp7qy8B8cGI76zfg/yCM3AGzsSkWBB/79KrkF/zi0v8R5ghKjgDZ+BMTIoF8esX/xPyC0mpE5yBM3AmJgHxQHz6yo4zt079cGL68Mf2vdTXJGvOZE0 DO6PbxVnb9UodNycfOXq1rzWPBvHnmqsC4j96Llg9a8eW8uT95 cn7y5MT2x77ZKPplfrkpW9MzOwZcq5Teyf514PbnFVievbo7AB rFaD5xaU7X3WUOm4Ki/7+qbuske053VxUF498e+KAJXX4yNGrugkyJcmZW6d+KFmRmPjR khEPA3JmeLENTNjhuJ25eOTbwRul24nK9uPm5ER56vWW0EJTYn j/aarfuHRki37lb61++sq04q/BaRkB4s81Vzvr98Ij/u7hRybKm+dP/Zgz99EXZlJHfGd55uC2Sb4mdw8/cn95crAVGwzxQ+bNhcPTEuIf3j49UZ49vnpXOUGmRJ2hWX7jzu mnpg8trybHIIZ4tsQseBgf4m/cOf298tQzZnazYgBnWPJIJ2ZJumPN335r9dM3tm9/xpzm7TfunN4b0UlRx+sNdxk93wRvEdOwiGd8lxDfWZ7VaumJve XJZ48q/zrD6+iJ8uZTpHHfoWf2uu3zp35Mp2Qg7izP2ie2bSEFOOuTNu4 79Ix/LoZ4viDWyMRORacCtqVPzS8u8ZfcSmI7yd84ccBaWeuyXfvaoR/eX55kxLlweNo1auq/Lt95ZdrbLtbPcXPy4UOnX5l2elhZ6zI8sc/8SGC1w8pal2Xza5dPuz7PHl/9lHU7UZ569ZLNZrzlNvI10W1RX6LO3Lh0ZDNZIpdu0cpt8U/pHlF8A71F8B4mylOvHXIQH5+HAzsTrdjJrNGubxb3I72Eur/sbHtM+z2qnOFihww/cLi848U8wsAa3O7s4junnyrPLvz+sGHUWEpIyUkPw1cv2ZzadG U8t0Xf2EEtZcWNS0f47pA61/5VtebCtg+D+HPNVT7iExLx9oltj5Yf9nPz7odPH9w2OfH977Cv n7z0DYZXp90h++ypveI07ufO0hPPfuvxTz56zmnf9tgnHz3HTi cOtd0JhLlIh2xBFPGBZyNBPX1Ehfi95NCie5rr/M+maVqzDmlG8gl4aew0Th9eXr3LspMtgh/PLG/4NFLW0nadApzRHa7umsjZr1w0c4ZZx7brwzufUCif/9k03SjeLe+NtfMe9pYn6cZG6+GQzkQrtnV08yXu0Izqd78Po4G d4RiV1pDngLMhdANV7UKH04c/vPPJG9u3sz/xizzF7AcsIZcuHdki5pJ01vFDn3rr7zzor4EFxOCIP9dcpZcDI uJndCKlsdBO0D/TWZ7pLD2xr/zQ/KkfM/I+e3TWm33bY60P9nSWZ1rPPzjx/e/4F8G7Ui5LmstF/AxB/AxfBxfx2s3h6vV6j03temxq17/+27/fX/z6/cWv93o9aZr5xaWVW3eUevsAqZvKswtf3GWNEweslVt3+OUhm5g PZdAenAOSdPjQwctOJ9OHz9/6UpqAd7W5PLvwxd3rn7ecWsDXG8vFhS/uerBj83IcaDaKSemMNI3fGWbIhNu/btF83fxbJE0pbSA7Vs/f+lKanrfH4WEkzkQi6icDB9tk6oZoUd/7fRgN4Awzn+0vmhXSseNtlKad9sn3oP8DnZ0umubMllnTMGp+A 3nn0kA8nz248zBrTjUg4s81V6WO+kP8+WeC2+0P9rDxGf5hQ8S 3nn+QUHLzqfPP0Ik3RDxbkB/xfNFhKM/S8b5/+mc/3zdEPNuLUiPLp2sr1t7y5FOLa/QQZaMEfC4d4tm8Dx28TCeg6TVRnn1z5U8sk/gihN7emWXT0KEJfgn54vKfwhyx1Bn/BDpnzv9smi1Cu+h3ZuX8dteWHvlPLa5JG+jNKE5PO4zcwwidGV I+rDv78dqK9T33s1dhDLrfh1G/zui2iH6mO0XXTsUTgJ353lz5k3ecvjNLDZEOQ+dM+fvDfK6Azr m8/FF1zv8aZs2pBkG8tXzT3xFFvP3BngAxbsrtrPQ+77XvKz90cHF PZ+kJznr7gz2c2vYHexisvfbyZmd2tyuh0RWdy/5gD0M8+3xw2+SjP/ku/5Ny9mD1ej2Wkcq/zi8uXbm+phTb3/7GiQPWletrHPHSBLSd7Wl1h4uzE+XZl+annAkWHahdub52bfnQ ZufzZZZAbBahN3d6MrF6KwLEnVH+Ve+Ms1baRZNtcTwRp+TMkj bwyqKDcrlntz0ODyN1ZhhdpjdvOEfYtmwRz1t+SxNTeGfYgSBt kbMj6J5yT9VB7b7cY1/fPjBp1GrC4ebmCRVrn5v9l4cOXma599LJQ5udDNR2LuWqsnMvk zdec0F9I95avnntjwqFR3zr+QcnypsPLnpfH/3Jd/98bicbi/em2fZY64M9rF2LePczxfGpvU4V/9WZx/eWPWo/+63HW+JcQYg/sW1LWSB+eMrr/hQ54mminJmbmpg+fFbdoXNI+/H09gF+JAs5d2Zuyo94Nk1wPgUfsbo/UWfOzE2JYPUA7V80TfFrKxYdi/c2xLFFgfizUg/Lh9j46dl4PBzSmcjkuUpWlW3C4iwtFOi2D7zfh1FIZ/iR4l/ha8ucsM4eZDtI1+6llu/cT097/tpCNZnTsyJvlxXc95ao6pz/dcM1l9Qf4nV87wvxjM7eRZ8LXEZkqZGO2EiI50/LMBCf2us+KvOT7+4rP8Qrel6VOCcV31wU8bQK4CehqBQZ4he96 zie2bz+Yv1IHTrwcifmQ/9GrfZUH4hfkwpAelIZRqIz3iJEEqkXzTecT0xrOrKGasSLPTiP T6gQH4GHQzsTjXxAFBJMuC0kuhf5fo8qZyZ8uKTbyO/rvHb59FMEnbp2f4Zwi6QqSroG4knifr38yrTGKxXEaZXm79z/V+2ai+oD8QF8lxD/53M7Ib/iuegeB8GZjDgTeC2YLSFnQios4q3lm5evXgkQEB8G8c1rn0N+w ZmMOMOKX+frykU23JG6CVlwZnQVy2/UfHXmccgvJKVOcCYrzqxcpAMymeV7Cs6MrID4RBF/6cptyC84A2fgTEwKQvzALwlMHabZFJJSJzgDZ+BMTIoe8T1rBx SgC83rkKT5xaXU1yGbgjNwZnix35hRIL536flBZO0I+JWJXIe1 o2ftiOmXPUZaF5rXU1+HbArOwJnhjWL4AeKjjIIvej0gPigLU1 +HbArOwJnhjXKgBMRHGEB8v1mY+jpkU3AGzgxvlAMlID7CAOL7 zcLU1yGbgjNwZnijHCgB8REGEN9vFqa+DtkUnIEzwxvlQAmIjz AiR/z1z1svlAs7j6X/tp2YsjCBpdw+trtQ/ml877IYXWdGUXAmvFEOlID4CKNQKExMH+71eiem7lMiniG7UJC pffvY7kKhwEm0sMv5nB/Ec2fc2L3whXqruTkhlwLEj4oWdhUKhUL5xeaKPx92ncyzMwMIi I8jGs/1egu7Hpg6sQHit5QnJegs7CrseHLGT6K8IV44vN2jekgB8SOh2 8d2F8q7d4o54M/8HDozmID4WKJQKBQK922I+J3HTu4sPPDCspO+t5d/Wi7sPri4R6jid52UEv32sd0Fdy6xxtEWvBmXDvEra90PX3zAcW P1+M7CAy/NT/Et9Zlzcqfjg2Sp0/jS/BQQn3GxXVmpt18A4iMSEB9LhEb83YVdIs52naTFph/xlO90ghVKw7SzaoAs5J/9Vbzjz+rxneJpTDKH2yK1C7OPmj95Axk7BBRXcr6Td96cGVhAf CwRHvG3j+12sLV6nFX0AYjftWeuLJeo3lfeQ+pZNUAW8s++sXh 3i1aP7xRvXSgvcVbIgAy7KuKnBAzUZFx8f0lXclwfvvgAP8fny plhBMTHEuERz8nlgUmPeP0ohKLMGSEFDNR4Vy0DIJ6fPsX21Ld 3MGfGW3Qn6hBPcyA/zgwpID6W6APx7sUpH7EJHqihozFSlTq6CkC8d1Sjih9vOQNxYo j7i1625siZ4QTExxJ9Id4txh0YBSOePmSiLXZGTTFV8WwW58TJ TAbiR0E0BxZ2iXee3D2YT2cGEBAfRzSeE7+fmLqv19MiXno0MB jxK2tdSi555HrUEMazkH/2jcULW90f4oWxrN0Lvz+8uTw7Wv7kE2QU8c7/FPGldz6dGUBAfCzhv+Ls9fADBkFZmPo6ZFNwBs4Mb5QDJSA+wg Di+83C1Nchm4IzcGZ4oxwoAfERBhDfbxamvg7ZFJyBM8Mb5UAJ iI8wgPh+szD1dcim4AycGd4oB0p+xM8vLg2g1F+OmnGl/iJHCIJyJe27Wwc7aaTO0Iyrs34PknSheT31dcim4AycGd4obRU/GOLnF5dS36psCkkJZ+AMnEneKCA+Oa9TX4dsCs7AGTgTn1FAfH Jep74O2RScgTNwJj6jgPjkvE59HbIpOANn4Ex8RgHxyXkdR7e2 VS0atY/t9DcwbmesarFYtVJf2ww6k0PBmfBGAfHRq1UzSm5ULZt7Taexq sUSCT5ZvxozxNt2q2ZQZ0zLtrljQHwexA4No9ZiX8nR5CVDPp0 ZQEB89Oo25wyXua2awfPSj3iexMNoLBHPnGGfOdaB+DzItqpFo 1r1csCquulNEyCHzgwmID5edZtzRtF4vdXphEC8zWhdq/KCRSxpvRKm25wzisVSqVQsGrXa2CK+s36PffEf4TpnbKtKr43Y 9MpGXhsW3R2UQeUNZGy3Vi0hB7hoMuTNmYEFxMcr26qGr+Jt2z L1QxM8v8U61zJLpXFFvIR77oZU3fNLJXaOZLxmqOi4J06psduc M4pV7nNmlTeQsR0k7Xcmluq8MW/ODCwgPkZJmRo4Fu8QyiSD8vQKoENQJeFpLAdqvIqbOMARLzugc obbom8sDnz/IxVnxl58T0kHDr8Io8N0uXJmGAHxMcqqFil8Q1bxIuKFW7KMd/TKoDOmiKeHN6e8V8VLDthu8UcKdlLyKxqpvZHcEUnAmfEW34kd Xw5wBdzZgnQC4uOSxPfOgIhXDCbkoYr3EE88CVfFywP0ykad51 lTfkDmjlIKISV2wJ0tSCcgPno5I8U+7PaLeF0tQwclGb/GGfHKKt43Fu/cpbCq/kdulI3S4oD4TInmQLc5Z/huuuTWmQEExEcv6fkNPobYL+I7/oFpF+WkMjWtVs0YO8RT97gh4hM1XtFHz3D0Dgd9FEdqpPsoyw9 i5hNk/lvu/hsz+XRmAAHxiXqd+jpkU1E5Qx+q67gnUWVj6pucsDPjJzgT3ig gPjmvU1+HbCoqZ/wPzhu1lrIx9U1O2JnxE5wJbxQQn5zXqa9DNhWVM9Igj/9KP+PPz8TnzPgJzoQ3CohPzuvU1yGbgjNwBs7EZ1TE726dX1xK 5oWEEARB0IaK+N2t84tLPYQqLrinU4QUcEYXcEYXcCZkXIhjoC bdTcpsICl1AWd0AWd0AWdCBhCfXCApdQFndAFndAFnQgYQn1wg KXUBZ3QBZ3QBZ0IGEJ9cICl1AWd0AWd0AWdCBhCfXCApdQFndA FndAFnQgYQH0u06xX+04YNt1FMyna9Qv6W76DO1CvUs17DLOXZ pryBjBw4ZLerDqe8OTNwAPFxRKNq1NrsEyEUEK8LwZmGWSpV6s y+dr3CP+cy8gWydt1wD5y2d6onCUE+5suZIQKIjzcoozZGvKJa ESdrmCTZK/W66U2rvHAYkZAOV35eFEt4ZYWn84e1N9xfoyTniYb4s+TZNiu/IONHjpAE3u7OrzN9BhAfa9CKdEPEe7U/OTEEIJ7ySTnvyIR8uLKNFrakTQdwyJcgxAvFnzORfBKId8OGjv yCzN1nYj573/LrTJ8BxMcTvFQkEOljoMb7YxDi1bOPBLrE8B+uDTOoWCdGBFfx gZN7E2c38goyD+VSycJ3Wl6d6TuA+HiDFp8bIp6ORGxUpcqIV8 07MqE4XCV7VJvLx6f6QHyok2SGIp8g09+OQRXfdwDxMQfJ0A0Q T5HTbxWvnndkYmPER1nFj9KJMIcgEwY3exiLHzaA+BiiXTeqlv sxdBUvDhgLnz3aq4aX9fOOSmyMeP9YvEsBjT8axDfM0fImZyBr 1ysl3+iZlNzKowmhDSA+jqC1opewfsSTqNTb3gB+pV4nKCLj+v phBs28oxEhEN8THoURKKD0R1fdiw/UYCw+UyE97FQST95BRxNCG0B8coGk1EVizuju3WU2kDO6gDMhA 4hPLpCUukjMGf+D9kD8iAacCRlAfHKBpNRFgs4I42MZ53sPOaM POBMygPjkAkmpCzijCzijCzgTMoIQj3e3QhAEjbqif3dr6i8dz 6Yu4J3xcAbOwJnEjdJW8UB85F6nvg7ZFJyBM3AmPqOA+OS8Tn0 dsik4A2fgTHxGAfHJeZ36OmRTcAbOwJn4jALik/M69XXIpuAMnIEz8RkFxCfndWLLsq1q0ah9bKe/1XE7Y1WLxarl/zweAsjgzPBGAfFxyaoWS6WSUWtxr/mfbLtVM4qlUqlq2XQW26qWSqXh6TzSiGe+8ZAs8psMxI+NWjXD v9+VjXlzZmAB8XHJtqpFo1o1igGIf3j7tARiq1o0TROI56ZtKC B+bNRtzhlu0rZqRqlkWratbMybM8MIiI9FjOBVq1ULRLzZaFSL xuutDmvsNueMYrXR8BDfbc4ZxSKtX/iM7Ef5ivLsRdZYqzmIp9Rj84anZ2IKg3h+3cN+gZAd5x094pXT s73iTGBVebttW6brMK8ZqbcZcSY/6jbnDJ//tDG3zvQrID4WMZRISPUjvmrZFGe06WP7nm1bVVK/uI2tmlHk9OFQo8tiwHKmJyBTHjZZUBjEU3xzNzoaxDsukem9kr BYZW5cfmu2UnGwztvpBFlQbkFG81bZmFtn+hUQH704JsIgnmet bVusoleOsUh98hFJPrHEJnqeoPVpNscxAsfiOZq9kxP3qqNBvO wG99Z1w7ZbNaPaaJhs73Bn2JVQ8Oh/is7kRMrLzYCjCQoQEB+xKIJDIZ5Dh0OZIJ7eaHLPBGrES1WP1A m/pMgOvKg2rOLpgJU0iqKu4iU3yLazzm3bMs0GG+dtic7wZWVhRC ufILOqRX+VIzXm05kBBMRHLIZsKYpGraNBfMdFMOeaktoDV/HevC7pU7fIr3CIV698X1U8d+bK4qxRa9l2643t2+vthukfEyBX P9lxJg8Kw/d8OjOYgPgYFaaK73hlo3vrT4V4q1rcoIq3LdMtPFmH/JDgNx6zOUrTCYH4gBvFIcfiiRtWtWiYZoUX9aZp+p3JyEVPrkD m7DUR5crGvDkzjID4GBUS8RKPaAHOR6WNWs0MRHxHGM0wrVbNI EcFG/BJHVg69f9ETakYeLu1I15O+Z9MpSdU6gz76syVgTNirkBGzee7 QNmYN2eGERCfqNdpLVr5fEJ2hMMVzsCZ+IwC4pPzOq1FZ/z/BOFwhTNwJj6jgPjkvE5luRm5c5hBZ7IvOANnhjcKiE/O69TXIZuCM3AGzsRnFN7dCkEQNLaK/t2t/b8lPBdxAe+M1wSc0QWc0QWcCRkX4hioSXeTMhtISl3AGV3AGV3 AmZABxCcXSEpdwBldwBldwJmQAcQnF0hKXcAZXcAZXcCZkAHEJ xdISl3AGV3AGV3AmZABxCcX4ZOyYZZKZiPWlclURH64EgPb9co IewmQ6QLOhAwgPo5o1yv0N4AdwCiTkr29SWJQzhHfEH+rcwAng PjRDXLwVOrtXq9HE8JtyaUzgwUQH0eosaJKyoZZqpimPDUQ7x3 KAwUQP6LRrlfkfd8wRdY7OzNvzgwcQHwcERrxDbNUqd+4dESaX EA8qWrcNtY/r22G5GH6EQrxWh8Us6kR78EiwEB6Bcb7bpilSr1uDnpRMXjkDG SKPS9C35sgZ84MHkB8HEExEXRp6SasXLsQQjWqRq3NO3UmYv07 X8ag5A+BeK0PYRFPi0G9gfQzWZByOC2JyBfI2vVKqVKRzuRCfn tf8uXMEAHExxvtekV7aSmxilBNTW0PaFq0jWgEjsX7jAjhg4z4 unQO1cyoONWyr6mdRvMFMnoaJkcOyYdKpQLE9xdAfNyhrTsEnv guR4VaUubd+CPev0F9+SAhXjkao0G8FEB8guEboPRfzKGK7zeA +JiDJKqYlFqc9Ggiy7DPK+L79ME/UCMCIwDxSpID8YlEQNXDArdb+w8gPvo4Mzcl1ONungpJKQwN93 rikI4S8Q0zx1W82gfSLIyuK2+3UoN1Biorxx4Qn1RItz8Cnq3J mzODBxAfQ9CxZJKlNClVzFDX7uSxj7qZW8SrfaDNZmPDJ2o8Rg QYKF5dpX1LO3cg8z83pXhOvtfLoTODBhCfXCApdQFndAFndAFn QgYQn1wgKXUBZ3QBZ3QBZ0IGEJ9cICl1AWd0AWd0AWdCBhCfXC ApdQFndAFndAFnQkYQ4vHuVgiCoFFX9O9uTf2l49nUBbwzHs7A GTiTuFHaKh6Ij9zr1Nchm4IzcAbOxGcUEJ+c16mvQzYFZ+AMnI nPKCA+Oa9TX4dsCs7AGTgTn1FAfHJep74O2RScgTNwJj6jgPjk vI6qK9uqFo3ax3Zk6xZ5h2k5k4wSs2vknElMcCa8UUB8LGrVDP bDGsWi8Xqr0xGT0rZbNaNIfx3Xsu3wnY834q0qdaZUtfpwJhkB 8fEZy/e7UWsFNObNmYEFxMeiVs3wI8CPeJ6vVrVYrFrh+x97xHNnsikg PhZXbavq1kPd5pxRNF5vdZSNeXNmGAHx0YsmpeQ1mUZAPEcGa+ d1K0VJtzlnFIvssqBWc9rpuYH2ySfmVTBbq1qtyi8alB2m4lgY xIfYotYb27fX295vT1rupRK/kBo5u3IFsm5zzihW2eUsP4iUjXlzZhgB8dGL1Rr8FZScKTrEs8 9sMh3ixekts1Ry2q0qH+QRCh8XQPx6gs3FJ9Z1mIpjGyI+/Baxr3wcjDnpzTJqduUNZFa1yM/N9BrX35g3ZwYWEB+9bKtaFC4tHWQHjMV75bwG8bSW6Qjot0wKM t9oD5+RTtlZ13aYimOBY/HyXQrdFknWUTc42UfOrhyCjO19yV5/Yw6dGUxAfPSipSKt/rRVvG96RRVPpumIiHFm8AFOoqQMRH2HySvMQM3GWxQC8SNnV65 AJp+A3Wssf2PenBlGQHz0ojeFQiHe9zl8Fd/hBaaLrs66fzgiQ2WpUhsP1ITYopCIHy27cgUy+pACPyiUjXlzZ hgB8dFLqtADHpoUHwtzKMNvCbJBHjogQ+8NSnlPB/2l3jQ1r7bD5NUX4vVbFArxo2VXrkDmO9cWq5atbMybM8MIiI9F/ic0OsGIJ0Bxb/SV2PtI/U/UlEqm1aoZBDFsnIE+P86Hs41azVQxK7jDhBVmoGbDLQqJ+NGyK 28go7dhxNutcmPenBlYQHyiXsfUs4SwkVPCh+sI2QWQwZnhjQL ik/M6pp77/Z9TWVPCh+sI2QWQwZnhjQLik/M6jm79QwojpyQP19GyCyCDM8MbBcQn53Xq65BNwRk4A2fiMwrv boUgCBpbRf/u1v7fEp6LuIB3xmsCzugCzugCzoSMC3EM1KS7SZkNJKUu4Iwu4 Iwu4EzIAOKTCySlLuCMLuCMLuBMyADikwskpS7gjC7gjC7gTMg A4pMLJKUu4Iwu4Iwu4EzIGBDxhUJh1BHfrlcq9XacS2iYJWEJS EpdwNIPbb8AAAHiSURBVBldwBldwJmQ0R/iOdn9H0YN8QJ/2YuCKI/b9UrJbAy5DOksgqTUBZzRBZzp9djRyH+2yWmDMyGj7yqeMZ3+O 5KIFyvshll6bGoXyZ9oEC8tBUmpCzijCzjDCjDnMCIf4UzIGGS gpuDG6A7UNEzK817DLD186HS94jWKiCdVhNsqTCB0R78IjEdS6 gLO6ALOiAeXd9jBmZDRB+IL+hg1xLfrFWFYxiExaaYEpznmTUK mWHlntlJRsl/4gqTUBZzRBZwRj1XvG5wJGfms4qUi3iu2+YWgx2bN6YB00q4Z1 UbD9JFfmLqHpNQHnNEFnJGOP35AwZmQkc+xeC3iOeRFxEvhDQx W6u1er2GajV67bhi1lt2SxvCB+DABZ3QBZ1DFDxn5fKImAPHOH +sC4jU3XtlsTv3efmP79nq7YYoTA/FhAs7oAs5gLH7IyOdz8drBF/5X6caq5gn6hlmqmGaFTdgwS6YpER5j8aECzugCzgiMJx/hTMjI6f9u9T9RI0CcQV79RE1JGhkUHp8pSQU/nqgJFXBGF3Cm16PHH46mviOniPdBPbalEOYjKXUBZ3QBZ3QBZ0 JGXhGfCOOlawUkpS7gjC7gjC7gTMjILeLxGzUZCjijCzijCzgT MrhR/w8t/MyRG9PhzgAAAABJRU5ErkJggg==

http://www.mikesdotnetting.com/images/Excel2.gif

http://www.mikesdotnetting.com/images/excel3.gif


string Access = Server.MapPath("App_Data/contacts.mdb");
string Excel = Server.MapPath("App_Data/Book1.xls");
string connect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Excel +";Extended Properties=Excel 8.0;";
using (OleDbConnection conn = new OleDbConnection(connect))
{
using (OleDbCommand cmd = new OleDbCommand())
{
cmd.Connection = conn;
cmd.CommandText = "INSERT INTO [MS Access;Database=" + Access + "].[Persons] SELECT * FROM [Sheet1$]";
conn.Open();
cmd.ExecuteNonQuery();
}
}


سلام
عبارت Server.MapPath رو نمیشناسه, چرا؟

[momimomi]

آقا این کدها که نوشتی تحت وبه برای ویندوز فرم چیکار باید کرد؟؟