By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,285 Members | 1,647 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,285 IT Pros & Developers. It's quick & easy.

Automating an import proccess

P: n/a
I looking for a way to automate an import of a fixed with text file
into access 2003. I know that I can use the DoCmd.TransferText command
to import the file but how do I go about setting where the column
breaks are?

Another problem that I have is that the data I need to get from the
text file is on different lines. The text file contains data about the
number of hours a employee has worked, but the name and the number of
hours are on different lines. Does anyone know a good way that I can
automatically match these up?

Aug 3 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Bill <wl*********@gmail.comwrote in
news:11**********************@e16g2000pri.googlegr oups.com:
I looking for a way to automate an import of a fixed with text
file into access 2003. I know that I can use the
DoCmd.TransferText command to import the file but how do I go
about setting where the column breaks are?

Another problem that I have is that the data I need to get
from the text file is on different lines. The text file
contains data about the number of hours a employee has worked,
but the name and the number of hours are on different lines.
Does anyone know a good way that I can automatically match
these up?
With the data for each record spread across multiple rows, the
transferText method becomes almost useless.

I use routines that reads the text file using the Open #, Input
# commands and examine the line, decide programmatically if the
row is the start of a new record or not, and write the data to a
recordset.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Aug 3 '07 #2

P: n/a
Hi,
Not that this is an Access solution but I have had to do that and I've
used a product called Monarch.
bobh.

On Aug 3, 10:04 am, Bill <wlippinc...@gmail.comwrote:
I looking for a way to automate an import of a fixed with text file
into access 2003. I know that I can use the DoCmd.TransferText command
to import the file but how do I go about setting where the column
breaks are?

Another problem that I have is that the data I need to get from the
text file is on different lines. The text file contains data about the
number of hours a employee has worked, but the name and the number of
hours are on different lines. Does anyone know a good way that I can
automatically match these up?

Aug 3 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.