473,320 Members | 1,990 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Scheduled import of text file

I've been developing an Access database for our small office for several
years now so I am not a newbie. However, I have a need for which I am not
finding a mechanism to accomplish in the material that I have read.

We use an antique BBX/BASIC accounting program which we use to generate
invoices. Every morning we save the previous day's invoices in a text file.
It is not a database or spreadsheet file, it is simply all of the invoices
laid out as they would print onto the invoice forms, one after the other.

We use access to manage our customers for the non-accounting branches of the
company.

It sure would be nice to somehow import the invoices into an Access table
and then be able to search/view/print invoices within Access (which has far
more such capability than the accounting program).

I've always felt that it should be possible to do this, but in my years of
working with Access, I've not seen anything that would help me get there.
I've just about figured that I would need to run a cron script on the server
to read the raw invoice files into a flat data file and then to import into
Access, but how do I then import the file into Access and then append to a
table on a schedule?

Frank
Nov 13 '05 #1
3 2856
In message <10*************@corp.supernews.com>, Frank Reichenbacher
<me@nospam-for-me.net> writes

I've always felt that it should be possible to do this, but in my years of
working with Access, I've not seen anything that would help me get there.
I've just about figured that I would need to run a cron script on the server
to read the raw invoice files into a flat data file and then to import into
Access, but how do I then import the file into Access and then append to a
table on a schedule?


Write a macro that imports the file then start Access with a
command-line switch to invoke the macro. You can do this as a scheduled
task in Windows. It's probably best to have it run overnight.
--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.

Nov 13 '05 #2
Frank,

Send me a copy of a typical text file.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

"Frank Reichenbacher" <me@nospam-for-me.net> wrote in message
news:10*************@corp.supernews.com...
I've been developing an Access database for our small office for several
years now so I am not a newbie. However, I have a need for which I am not
finding a mechanism to accomplish in the material that I have read.

We use an antique BBX/BASIC accounting program which we use to generate
invoices. Every morning we save the previous day's invoices in a text file.
It is not a database or spreadsheet file, it is simply all of the invoices
laid out as they would print onto the invoice forms, one after the other.

We use access to manage our customers for the non-accounting branches of the
company.

It sure would be nice to somehow import the invoices into an Access table
and then be able to search/view/print invoices within Access (which has far
more such capability than the accounting program).

I've always felt that it should be possible to do this, but in my years of
working with Access, I've not seen anything that would help me get there.
I've just about figured that I would need to run a cron script on the server
to read the raw invoice files into a flat data file and then to import into
Access, but how do I then import the file into Access and then append to a
table on a schedule?

Frank

Nov 13 '05 #3
Frank,

I got your text file. I tried to email you back but the address in your email
failed. Please send me an address which I can use to email you back.

Steve
PC Datasheet

"Frank Reichenbacher" <me@nospam-for-me.net> wrote in message
news:10*************@corp.supernews.com...
I've been developing an Access database for our small office for several
years now so I am not a newbie. However, I have a need for which I am not
finding a mechanism to accomplish in the material that I have read.

We use an antique BBX/BASIC accounting program which we use to generate
invoices. Every morning we save the previous day's invoices in a text file.
It is not a database or spreadsheet file, it is simply all of the invoices
laid out as they would print onto the invoice forms, one after the other.

We use access to manage our customers for the non-accounting branches of the
company.

It sure would be nice to somehow import the invoices into an Access table
and then be able to search/view/print invoices within Access (which has far
more such capability than the accounting program).

I've always felt that it should be possible to do this, but in my years of
working with Access, I've not seen anything that would help me get there.
I've just about figured that I would need to run a cron script on the server
to read the raw invoice files into a flat data file and then to import into
Access, but how do I then import the file into Access and then append to a
table on a schedule?

Frank

Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

10
by: Larry Neylon | last post by:
Hi All, I want to perform the simple task of running an ASP script as a scheduled job. Previously I've always either run a .vbs script via windows Scheduler, or put some logic in my...
1
by: TiredOfSpam | last post by:
I have an ActiveX Script task in a DTS package which executes fine within DTS. However, if I run it as a sheduled job, it fails with a 'path not found error'. I've cut the code down to the...
2
by: David Olive | last post by:
Hi guys, I'm having a bit of a problem getting a VB .NET console app to run happily as a scheduled task. The app itself generates a bunch of word documents on a file share on another server by...
11
by: Peter Neumaier | last post by:
Hi! I scheduled a DTS-Import from MySQL, whenever I run it manually (Right-Click on the DTS package) it runs through without any problems. But firing it by a schedule doesn't work!? Just to...
4
by: DFS | last post by:
I have two nightly scheduled jobs at a client site - one at 2:00am and the other at 5:00am Both jobs launch Access 2003, log into the default system workgroup, open a Access .mdb that collects...
4
by: RSH | last post by:
I have an application that creates an Access version of a SQL Server database and then it moves the resulting database to an ftp server for the client to download and run reports against etc. The...
3
by: Steve | last post by:
Here is what I want to do. Currently I have to log into 30 servers every morning and see if all the jobs under 'scheduled tasks' ran. Is there a way from .NET to read that directory for the selected...
11
by: Jim | last post by:
Hi, I want to schedule a Python program that reads the command line for input. However, when adding an argument to the command line Python will not pick it up when using Windows scheduled...
9
by: jdaelhousen | last post by:
I have a bit of a problem I'm hoping someone can shed some light on... I have a VB.Net console application written in VS 2003 that produces a .exe file that now sits on a Windows 2000 server...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.