[AccessD] Access To Excel via a CSV File

Mark A Matte markamatte at hotmail.com
Thu Jun 5 10:15:32 CDT 2008


Max,

Why are you try to go CSV first?

Thanks,

Mark

----------------------------------------
> From: max.wanadoo at gmail.com
> To: accessd at databaseadvisors.com
> Date: Thu, 5 Jun 2008 15:57:06 +0100
> 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

_________________________________________________________________
Search that pays you back! Introducing Live Search cashback.
http://search.live.com/cashback/?&pkw=form=MIJAAF/publ=HMTGL/crea=srchpaysyouback



More information about the AccessD mailing list