RE: Importing Data for use in report
- From: Graveyardblues <Graveyardblues@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 16 Nov 2006 10:22:01 -0800
Klatuu, Hope your still out there .....
Well, I used the Transfer Text under Macro ??? That works perfectly, I
set it to open my Test.Txt file, then added open Report to the Macro, works
pretty good, opens the report using my sample Test.txt.
Now, I want to modify the Macro to Prompt me for the Data file, that way I
can choose different Data files without going into the design of the MAcro
every time I would like to open a differant data file. Additionally, I want
to modify it so that after it opens the specific Data File, it opens the
report & automatically changes the Record Source to whatever Data file I
choose to import ?? Can this be Done ?? I would think so, but I cannot
figure it out !!!
Thanks For Your Help !!!!!!!!!
Aaron
"Klatuu" wrote:
Okay, post back if you get stuck in the mud..
"Graveyardblues" wrote:
THANKS,
I like the idea, not exactly sure how to do it, But I think that sounds
really good, I will figure it out !!!!
Thanks for the help
"Klatuu" wrote:
I would create a table with the correct fields, field names, and data types.
I would create an import specification for the import to pull the data in
correclty.
Then to import the file, I would use the TransferText method in VBA (a Macro
will do if you don't know VBA) and transfer into the existing table rather
than creating a new table. This way, you will have the correct data types.
"Graveyardblues" wrote:
Thanks for your help.....
I am importing by Hand ?? I think....I right click on the table, go to
Import & create a new table using the .TXT file, the only option I check is
"First Row Contains Headers". The program that I am exporting from only
exports records in .TXT format. I always export the same fields, but the
data is different for every export...Might there be a better way to
accomplish this ? I have different people in my office each using this
method, so, I would love it if I could simplify it.....
"Klatuu" wrote:
How are you doing the import? by hand, in VBA, in a Macro?
Are you importing to a new table or an existing table?
"Graveyardblues" wrote:
The format property of the Text Box only seems to work if I change the
field's in the table from .TXT to Number....
Is there any other way to change the format in the report if the field is a
.TXT ????
Thanks for helping Klatuu
"Klatuu" wrote:
Use the format property of the text box where you want to display your
currency to format the display.
"Graveyardblues" wrote:
I have created a Report based on Data that is exported out of another program
in .TXT format.
After I import the data as a table I set the report control source to match
& print out report using imported data.
All works great, except, when the data is imported it set's all fields to
txt fields in Table. In my report there are 3 currency fields, but I cannot
choose a format type of currency unless I change each field in the table to
be a Number field....
Is there an easier way to display $1,000.00 instead of 1000 ??? Using my
field as a .TXT ????
PLEASE HELP
- Follow-Ups:
- RE: Importing Data for use in report
- From: Klatuu
- RE: Importing Data for use in report
- Prev by Date: Re: Drawing vertical lines in the detail section
- Next by Date: Re: Report_NoData Event
- Previous by thread: Re: Limit the number of records in a group that print on a report
- Next by thread: RE: Importing Data for use in report
- Index(es):
Relevant Pages
|
