导入Excel文件只有两个选项？ [英] Only two options to import Excel files?
问题描述
在Excel中将它们转换为CSV，然后使用TransferText（它不能正常工作，也不能直接接受XLS / Excel文件）或
创建链接到Excel XLS工作簿并执行追加查询（因为这里有一些
建议）??
我觉得很难相信Access是部分MS Office和Visual
FoxPro不是。我使用两者分配时间，我可以在VFP中对XLS执行简单的复制
命令，或者对DBF执行附加命令或使用Office
自动化使用VFP构建工作簿缓解。多年来我一直在做
。
TransferText错误地将一些信息转换为空白
字段（看起来像一个废话射击）。我不知道CSV（希望它可以是一个XLS）文件是什么，直到我从选择的
用户对话框返回文件名和路径文件。
-pw
这里有问题吗？ />
5月19日，11：18 * pm，PW< paulremove_williamson ... @ removehotmail.com>
写道：
在Excel中将它们转换为CSV，然后使用TransferText（这不是
正常工作，也不直接接受XLS / Excel文件）或
创建一个指向Excel XLS工作簿的链接并执行追加查询（因为这里有一些
建议）??
我发现很难相信Access是MS Office和Visual的一部分
FoxPro不是。 *我使用两者分配时间，我可以在VFP中对XLS执行简单的复制
命令，或者对DBF执行附加命令或使用Office
自动化使用VFP构建工作簿轻松。 *多年来我一直在做
.
TransferText错误地将一些信息转换为空白
字段（似乎像一个废话射击）。 *我不知道CSV（希望它可以是一个XLS）文件是什么，直到我从
用户对话框返回文件名和路径选择文件。
-pw
2008年5月19日星期一20:27:04 -0700 （PDT），lyle fairfield
< ly ************ @ gmail.comwrote：
>这里有问题吗？
我还有其他选择????
-pw
>
5月19日，11：18 * pm，PW< paulremove_williamson ... @ removehotmail.com>
写道：
>在Excel中将它们转换为CSV，然后使用TransferText（它不能正常工作，也不直接接受XLS / Excel文件）或
创建链接到一个Excel XLS工作簿并做一个追加查询（正如一些
在这里建议的那样）??
我发现很难相信Access是MS Office和Visual的一部分
FoxPro不是。 *我使用两者分配时间，我可以在VFP中对XLS执行简单的复制
命令，或者对DBF执行附加命令，或者使用Office
自动化轻松地使用VFP构建工作簿。 *我多年来一直在做这个。
TransferText错误地将一些信息转换为空白字段（似乎是一个废话拍摄）。 *我不知道CSV（希望它可能是一个XLS）文件是什么，直到我从选择文件的
用户对话框返回文件名和路径。
-pw
" PW" < pa ********************** @ removehotmail.comwrote in message
news：7j ******** ************************ @ 4ax.com ...
>
例如，在Access 2003中是否有这样的命令。这是来自Visual FoxPro8的
已经被打了多年但是却没有
部分MS Office套件而不是Visual Studio的一部分仍然可以轻松地将数据传输到Excel和从Excel传输数据（以及DBF文件）！：
从另一个
文件中将记录添加到当前所选表的末尾。
以下是要插入的查询的一些示例SQL记录到Access表中
从名为C的Excel文件中命名为MyAccessTable：\ Sample \ MyExcelFile.xls：
INSERT INTO MyAccessTable（FieldA，FieldB） ）SELECT FieldA，FieldB FROM [Excel
8.0; HDR = YES; IMEX = 2; DATABASE = C：\ Sample \ MyExcelFile。 xls]。[MyExcelWorksheet];
你可以用文本文件或dBase文件做类似的事情。
- 史蒂夫
Convert them to CSV in Excel, then use TransferText (which does not
work correctly and also doesn''t accept XLS/Excel files directly) or
create a link to an Excel XLS workbook and do an Append Query (as some
have suggested here)??
I find that hard to believe as Access is part of MS Office and Visual
FoxPro is not. I split my time using both and I can do a simple copy
command to XLS in VFP or an Append command to DBF or use Office
Automation to build workbooks using VFP with ease. I''ve been doing
this for years.
TransferText is incorrectly transposing some information as blank
fields (seems like a crap shoot). I don''t know what the CSV (wish it
could be an XLS) file is until I return the file name and path from a
user dialog box that selects the file.
-pw
Is there a question here?
On May 19, 11:18*pm, PW <paulremove_williamson...@removehotmail.com>
wrote:Convert them to CSV in Excel, then use TransferText (which does not
work correctly and also doesn''t accept XLS/Excel files directly) or
create a link to an Excel XLS workbook and do an Append Query (as some
have suggested here)??
I find that hard to believe as Access is part of MS Office and Visual
FoxPro is not. *I split my time using both and I can do a simple copy
command to XLS in VFP or an Append command to DBF or use Office
Automation to build workbooks using VFP with ease. *I''ve been doing
this for years.
TransferText is incorrectly transposing some information as blank
fields (seems like a crap shoot). *I don''t know what the CSV (wish it
could be an XLS) file is until I return the file name and path from a
user dialog box that selects the file.
-pw
On Mon, 19 May 2008 20:27:04 -0700 (PDT), lyle fairfield
<ly************@gmail.comwrote:
>Is there a question here?Do I have any other options????
-pw
>
On May 19, 11:18*pm, PW <paulremove_williamson...@removehotmail.com>
wrote:>Convert them to CSV in Excel, then use TransferText (which does not
work correctly and also doesn''t accept XLS/Excel files directly) or
create a link to an Excel XLS workbook and do an Append Query (as some
have suggested here)??
I find that hard to believe as Access is part of MS Office and Visual
FoxPro is not. *I split my time using both and I can do a simple copy
command to XLS in VFP or an Append command to DBF or use Office
Automation to build workbooks using VFP with ease. *I''ve been doing
this for years.
TransferText is incorrectly transposing some information as blank
fields (seems like a crap shoot). *I don''t know what the CSV (wish it
could be an XLS) file is until I return the file name and path from a
user dialog box that selects the file.
-pw
"PW" <pa**********************@removehotmail.comwrote in message
news:7j********************************@4ax.com...>
For instance, is there any command like this in Access 2003. This is
from Visual FoxPro8 which has been bashed for years but yet as not
part of the MS Office suite and not part of Visual Studio can still
transfer data to and from Excel with ease (and to a DBF file)!:
Adds records to the end of the currently selected table from another
file.
Here is some sample SQL for a query to insert records into an Access table
named MyAccessTable from an Excel file named C:\Sample\MyExcelFile.xls:
INSERT INTO MyAccessTable (FieldA, FieldB) SELECT FieldA, FieldB FROM [Excel
8.0;HDR=YES;IMEX=2;DATABASE=C:\Sample\MyExcelFile. xls].[MyExcelWorksheet];
You can do similar things with text files or dBase files.
- Steve
这篇关于导入Excel文件只有两个选项？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
