Re: Write to Access 2000 database - recommendations

From: Arthur Richards (fake_at_address.com.au)
Date: 06/12/04 

Date: Sat, 12 Jun 2004 17:35:22 +1000

Thanks for your reply, I'll have a look at it.

I think though that I need something like a "TTable for Access" because I
need to do some calculations on the source file before adding to the
database.

Regards,
Arthur

"Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message
news:40caaa69$1@newsgroups.borland.com...
> The easest and fast way is to execute query like (using
> Microsoft.Jet.OLEDB.4.0 provider):
>
> SELECT * INTO MyTable FROM FileName#txt IN ""[Text;DATABASE=C:\Path]
>
> You may need to place schema.ini file into directory with text files that
> describes text file strcture - look for "schema.ini" in MSDN for details.
>
> //------------------------------------------
> Regards,
> Vassiliev V. V.
> http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
> ADO.Net
> http://www.oledbdirect.com - The fastest way to access MS SQL Server,
> MS Jet (Access) and Interbase (through OLEDB)
>
> "Arthur Richards" <fake@address.com.au> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
> ÓÌÅÄÕÀÝÅÅ: news:40ca6e6b@newsgroups.borland.com...
> > I need to convert a large number of text files with fixed column spacing
> to
> > Access 2000 files using D5 pro. I have used BDE TTable & TQuery,
Advantage
> > and kbmMemTable but have no experience at all with Access.
> >
> > This a one off task so I would like the quickest & simplest solution.
> >
> > Thanks
> > Arthur Richards
> >
> >
>
>

Relevant Pages

  • Re: Excel 2007 calculate time between 2 date/time columns
    ... you cannot format this to display what you want because Excel will not display more than 31 days in a date format. ... calculations), so still learning. ... >> Best Regards, ...
    (microsoft.public.excel.misc)
  • Re: Excel 2002 Random Exe Error
    ... Have you tried clearing out any Temp files. ... and the calculations to bring the data into ... throw an exe error, and it is not recoverable after that. ...
    (microsoft.public.excel.programming)
  • Re: Parser Error Help
    ... Check whether you have change the namespace or the class name? ... Regards, ... > details and modify your source file appropriately. ... > Parser Error Message: ...
    (microsoft.public.dotnet.faqs)
  • Re: Time format
    ... "How to handle midnight in calculations" ... > Some time a staff works from 16:00 hrs. to midnight 02.00 hrs. ... >>> Regards ... >>> Irshad ...
    (microsoft.public.access.forms)
  • Re: Optimize SumProduct
    ... > Frank Kabel ... >> both of the calculations are essentially the same except for the ... >> column to sum, is there a way to check the conditions I have once, ...
    (microsoft.public.excel.misc)