[AccessD] Access To Excel via a CSV File

Hi Max,
To use Docmd.transferspreadsheet the target file need to exist first. So if
you go to the table and use office links to create the Excel Spreadsheet
initially you can then blank everything except the header columns (ie use it
like a template.)
All the fields will be correctly formatted as per the source fields in the
Access Table....
HTH
Rgds
Robin 



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: 05 June 2008 15:57
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access To Excel via a CSV File


I thought there may be some way to turn it into an xls file and then with
(xls type code - range thingy) format it. If I just rename it to .xls all
the csv value turn into one line string. If I try to
docmd.transferspreadsheet acimport into a table and then
docmd.transferspreadsheet acexport I cannot get past first base as it won't
let me do an import.

Yes, definitely stumped.  More stumps than criket!

Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Thursday, June 05, 2008 3:44 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Access To Excel via a CSV File

Hi Max

Stumped you must be. An CSV file does not carry any fancy info, only data as
text. It is simply a text file with a funny extension.

/gustav

>>> max.wanadoo at gmail.com 05-06-2008 16:33 >>>

Can any of you Access/Excel gurus help here please.
I need to create a csv spreadsheet by code.  When it is complete, I need to
put formatting on it. Ie,make columns into Currency Types. Bold some Rows,
set some bacground colours, etc. I have got as far as creating the CSV ok
but then I am stumped. Any advice most welcome. Ta Max



--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com