Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Microsoft Access > Only two option...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 21 Topic 30321 of 31596
Post > Topic >>

Only two options to im****t Excel files?

by PW <paulremove_williamson858@[EMAIL PROTECTED] > May 19, 2008 at 09:18 PM

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
 




 21 Posts in Topic:
Only two options to import Excel files?
PW <paulremove_william  2008-05-19 21:18:04 
Re: Only two options to import Excel files?
lyle fairfield <lyle.f  2008-05-19 20:27:04 
Re: Only two options to import Excel files?
PW <paulremove_william  2008-05-19 21:44:54 
Re: Only two options to import Excel files?
PW <paulremove_william  2008-05-19 21:52:04 
Re: Only two options to import Excel files?
"Sky" <sky @  2008-05-20 14:47:31 
Re: Only two options to import Excel files?
PW <paulremove_william  2008-05-20 12:51:19 
Re: Only two options to import Excel files?
"Sky" <sky @  2008-05-20 19:40:38 
Re: Only two options to import Excel files?
PW <paulremove_william  2008-05-21 16:14:33 
Re: Only two options to import Excel files?
"Sky" <sky @  2008-05-22 01:32:55 
Re: Only two options to import Excel files?
PW <paulremove_william  2008-05-21 20:45:31 
Re: Only two options to import Excel files?
PW <paulremove_william  2008-05-21 20:53:07 
Re: Only two options to import Excel files?
PW <paulremove_william  2008-05-22 10:31:15 
Re: Only two options to import Excel files?
PW <paulremove_william  2008-05-22 10:41:27 
Re: Only two options to import Excel files?
Salad <oil@[EMAIL PROT  2008-05-22 10:24:14 
Re: Only two options to import Excel files?
PW <paulremove_william  2008-05-22 11:31:52 
Re: Only two options to import Excel files?
Salad <oil@[EMAIL PROT  2008-05-22 12:02:07 
Re: Only two options to import Excel files?
PW <paulremove_william  2008-05-22 13:23:52 
Re: Only two options to import Excel files?
lyle fairfield <lyle.f  2008-05-21 16:56:14 
Re: Only two options to import Excel files?
PW <paulremove_william  2008-05-21 21:03:12 
Re: Only two options to import Excel files?
PW <paulremove_william  2008-05-21 21:18:31 
Re: Only two options to import Excel files?
CDMAPoster@[EMAIL PROTECT  2008-05-22 13:16:57 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Fri Dec 5 8:10:03 CST 2008.