使用x64机器导入Excel [英] Excel import with x64 machine
问题描述
我轻松将.Net 2.0 c＃app移植到x64，但还有一个主要问题：
问题：app导入excel数据通过OleDB，在x64平台上没有
64位应用程序可用的没有ODBC潜水员（除了SQL Server）。
我有x64，Sql Server（必须支持2000和2005）和Excel表格
（必须能够导入混合模式数据），有人可以指向我吗？ />
方向解决这个问题没有太多麻烦？
TIA任何帮助，
问候
DC
Hi,
I easily ported a .Net 2.0 c# app to x64, but there is one major
problem left: the app imports excel data via OleDB, and there are no
Jet drivers and no ODBC divers (other than SQL Server) available for
64 bit apps on the x64 platform.
I have x64, Sql Server (must support 2000 and 2005) and Excel sheets
(must be able to import mixed mode data), can someone point me into a
direction to get this solved without too much trouble?
TIA for any help,
Regards
DC
推荐答案
DC，
你有没有想过运行你的应用程序在32位兼容模式下？
这可能是您唯一的选择。
-
- Nicholas Paldino [.NET / C＃MVP]
- mv*@spam.guard.caspershouse.com
DC < dc@upsize.dewrote in message
news：11 ********************** @ w5g2000hsg.googlegro ups.com。 ..
DC,
Have you thought about running your app in 32 bit compatability mode?
This might be your only option.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com
"DC" <dc@upsize.dewrote in message
news:11**********************@w5g2000hsg.googlegro ups.com...
我轻松将.Net 2.0 c＃app移植到x64，但有一个主要的<问题还剩下：
问题：应用程序通过OleDB导入excel数据，没有
Jet驱动程序和没有ODBC潜水员（除了SQL Server）可用于
$ b x64平台上的$ b 64位应用程序。
我有x64，Sql Server（必须支持2000和2005）和Excel工作表
（必须能够要导入混合模式数据），有人可以指点我这个方向来解决这个问题而不会有太多麻烦吗？
TIA提供任何帮助，
问候
DC
Hi,
I easily ported a .Net 2.0 c# app to x64, but there is one major
problem left: the app imports excel data via OleDB, and there are no
Jet drivers and no ODBC divers (other than SQL Server) available for
64 bit apps on the x64 platform.
I have x64, Sql Server (must support 2000 and 2005) and Excel sheets
(must be able to import mixed mode data), can someone point me into a
direction to get this solved without too much trouble?
TIA for any help,
Regards
DC
" Nicholas Paldino [.NET / C＃MVP]" < mv*@spam.guard.caspershouse.com写在
消息新闻：％2 **************** @ TK2MSFTNGP02.phx.gbl .. 。
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.comwrote in
message news:%2****************@TK2MSFTNGP02.phx.gbl...
您是否考虑过以32位兼容模式运行应用程序？这个
可能是你唯一的选择。
Have you thought about running your app in 32 bit compatability mode? This
might be your only option.
我最近有一个类似的问题是Jet而不是Excel，但是
的原理是一样的......
据我所知，除了SQL Server之外，其他任何东西都没有64位OleDb驱动程序 - 因此，编写64位应用程序是不可能的
以这种方式与数据库接口...
最后我别无选择，只能强迫应用程序在32位后编译/>
，当然，一切都很好......
I had a similar problem recently with Jet rather than Excel, but the
principle is the same...
As I understand it, there are no 64-bit OleDb drivers for anything other
than SQL Server - therefore, it''s not possible to write 64-bit apps which
interface with databases in this way...
In the end I had no choice but to force the app to compile in 32-bit after
which, of course, everything was fine...
感谢提示并抱歉提出了一个额外的愚蠢问题（我
我不太了解x64架构...）：我猜当应用程序是在bbit模式下运行
时，它的行为也会像在Win32
并且地址不超过2GB？那是没有选择的，因为
使用大量内存的能力是为什么应用程序首先被移植到x64的
。
我不可能至少桥接 64位OleDB
32位OleDB驱动程序（或ODBC驱动程序）的驱动程序。这让我感到很尴尬。我想知道MS对x64系统的贡献是多少。
我会寻找其他解决方案，例如写一个小写的32位程序
只执行Jet Imports（并以某种方式与64位
进行通信，我不知道除了交换文件之外的其他方式）还是有SQL
服务器将Excel数据导入临时表，但遗憾的是
这是必要的。我的应用程序是一个Windows服务，我想知道如果我不得不使用图形和
打印机驱动程序，那么
移植问题会有多深。
问候
DC
在10 Mai，18：18，Mark Rae < m ... @ markNOSPAMrae.netwrote：
Thanks for the hints and sorry for an additional stupid question (I
don''t know much about x64 architecture...): I guess when the app is
run in 32 Bit mode, it will also behave like it was run under Win32
and not address more than 2GB? That is no option then, since the
ability to use huge amounts of RAM is why the app was ported to x64 in
the first place.
I could not have been that hard to at least "bridge" the 64 Bit OleDB
Drivers to the 32 Bit OleDB Drivers (or ODBC drivers). This makes me
wonder how much dedication MS spents to x64 systems.
I will look for other solutions like write a litte 32 Bit Program that
only executes the Jet Imports (and communicates with the 64 Bit
somehow and I don''t know how other than exchanging files) or have SQL
Server import the Excel data to a temp table, but it is a pity that
this is necessary. My app is a windows service, I wonder how deep the
porting issues would possibly be if I had to work with graphics and
printer drivers.
Regards
DC
On 10 Mai, 18:18, "Mark Rae" <m...@markNOSPAMrae.netwrote:
" Nicholas Paldino [.NET / C＃MVP]" < m ... @ spam.guard.caspershouse.com写在
messagenews：％2 **************** @ TK2MSFTNGP02.phx.gb l ...
"Nicholas Paldino [.NET/C# MVP]" <m...@spam.guard.caspershouse.comwrote in
messagenews:%2****************@TK2MSFTNGP02.phx.gb l...
您是否考虑过以32位兼容模式运行应用程序？这个
可能是你唯一的选择。
Have you thought about running your app in 32 bit compatability mode? This
might be your only option.
我最近有一个类似的问题是Jet而不是Excel，但是
的原理是一样的......
据我所知，除了SQL Server之外，其他任何东西都没有64位OleDb驱动程序 - 因此，编写64位应用程序是不可能的
以这种方式与数据库接口...
最后我别无选择，只能强迫应用程序在32位后编译/>
当然，一切都很好......
I had a similar problem recently with Jet rather than Excel, but the
principle is the same...
As I understand it, there are no 64-bit OleDb drivers for anything other
than SQL Server - therefore, it''s not possible to write 64-bit apps which
interface with databases in this way...
In the end I had no choice but to force the app to compile in 32-bit after
which, of course, everything was fine...
这篇关于使用x64机器导入Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
