Only two options to import Excel files?

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

.

Relevant Pages

  • Re: Code looping through files new line
    ... If there is the ability to direct save as a csv I'll give it a try. ... No there were no manual manipulations she just saved them in .xls format... ... Tom Ogilvy ... Once opened I save it as an Excel .xls file ...
    (microsoft.public.excel.programming)
  • Re: Any way to make OleDb read an Excel file?
    ... The prerequisite of using Office Object Model is to install the Office ... Since your customers do not have Excel ... CSV file is a plain text file type that stores ... similar to what we used to do in Excel xls files. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Need a tool to convert .csv to .xls
    ... Is there no workstation with Excel already licensed where you could use ... Excel to convert the csv to xls? ... This is input data for data driven scripts used by ...
    (microsoft.public.excel)
  • Re: Code looping through files new line
    ... If there is the ability to direct save as a csv I'll give it a try. ... No there were no manual manipulations she just saved them in .xls format... ... Once opened I save it as an Excel .xls file ... Dim fso As Object, fl As Object ...
    (microsoft.public.excel.programming)
  • Re: Table import dialog box
    ... Then use TransferText to import a CSV, or TransferSpreadsheet to import an XLS. ... Tips for Access users - http://allenbrowne.com/tips.html ...
    (comp.databases.ms-access)
Loading