[AccessD] CSV file from hell

Hi Andy,
No - we're 'the other' outdoor theatre in Cornwall, its Sterts at Upton 
Cross (near Liskeard) .(www.sterts.co.uk)
The difference is that we've got a canopy over the whole stage and audience 
so we don't have too much problem with the rain ....
It's the best thing I ever did moving down here - I can see Bodmin Moor on 
the way to work (6 miles through country lanes) and Dartmoor on the way 
back!

If you've got a moment Andy could you just run a quick docmdtransfertxt 
without the destination table being present and let me know what error 
number you get.
I still haven't solved the problem - it either gives me error 3107 or 3011 
but inconsistently
I'll rewrite it on to a work computer on Monday and see what happens

Regards
Robin


----- Original Message ----- 
From: "Andy Lacey" <andy at minstersystems.co.uk>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Saturday, May 15, 2010 7:06 PM
Subject: Re: [AccessD] CSV file from hell


> Hi Robin
>
> Is that the Minack by any chance?
>
> Andy
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robin Lawrence
> Sent: 15 May 2010 11:16
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] CSV file from hell
>
>
> Hello to all,
> I haven't been active in Access for about 10 years, was in the forum then
> but I'm afraid more from the listening end (You're all so quick I hardly
> ever got a chance to get an answer in!)
> Anyway I've moved down to Cornwall (UK) and have a part time job
> administrating for a theatre, they have been writing tickets out by hand 
> for
> 20 years ( 400 seater / 73 shows in the season!)
> Needless to say I couldnt resist offering to sort that one out.......
>
> Enough waffle - down to the problem
>
> I have a csv file coming from the web site ( no possibility of changing 
> the
> format at present) which I'm importing into the local box office system
>
> The problem is there is a section in the middle of the file which can 
> vary,
> ie between two fixed fields  extra fields can be added. I've figured out 
> how
> to handle this in code once the file is imported to a table in the 
> database.
>
>
> I've been importing the file manually - taking the option to overwrite the
> table when asked so that any extra fields (since the last import) will be
> included in the field definitions, it all works fine
> I'm now trying to automate this in code so that the operators can have a
> 'press button' menu to import and process the orders.
>
> Problem is with using 'docmd.transfertext' I dont get the option to
> overwrite the table, then the fields don't match and I get an error....
> If I delete the table completely first the it complains about it not being
> there....
>
> Just wanted to ask if there was any way to force docmd.transfertext to add 
> a
> new table before I start writng code to open the file directly and parse 
> it
> myself ?
>
> (I have tried to link rather than import the file but it doesn't read the
> values correctly)
>
> Regards
> Robin Lawrence
>
>
>
> -- 
> 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
>