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 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.
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
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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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)...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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....
|
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
|
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...
| |