Transfertext to Excel

[Guest]

Need help in building a database. I need the database to upload a raw file
(text form) and then have it
transfer it to excel form (whatever columns and data in the temp table, i
need it to be filled in excel)
Also, in this excel file will be 3 more columns and after everythign is
filled out, it should be transfered
back into the database and depending on the comments field (drop down) it
will go onto the different tables
Right now, i have the datbase uploading the text file. I'm stuck on how to
get all the data from a temp table
and extporting it to excel and then have it import it back to access.
Please help

 

[David Lloyd]

Justin:

I don't know all the particulars of your situation, so I will just make some
general comments. One possibility is to directly import the text file into
Excel. Excel allows you to import both fixed width and delimited text
files. From your post it sounds as though you may be importing the text
file into Access and then just turning around and exporting it to Excel.
The direct approach would save you a step, provided there are no other
operations that need to be performed.

Once you have added the three additional columns in Excel, you can either
import the data in Access, or link the worksheet into Access. From there
you can write a queries to load the data into your other tables.

As a side note, Access also has a TransferSpreadsheet method similar to the
TransferText method for importing and linking from and exporting to Excel.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Need help in building a database. I need the database to upload a raw file
(text form) and then have it
transfer it to excel form (whatever columns and data in the temp table, i
need it to be filled in excel)
Also, in this excel file will be 3 more columns and after everythign is
filled out, it should be transfered
back into the database and depending on the comments field (drop down) it
will go onto the different tables
Right now, i have the datbase uploading the text file. I'm stuck on how to
get all the data from a temp table
and extporting it to excel and then have it import it back to access.
Please help

 

[Guest]

ok, let me tell you my reason,
My company has 3 company (1 in LongIsland, 1 in NJ and one in CT). Now the
Director of Warehouse wants
to have a database to do the things i mentioned before. I wanted to do
direct link into excel but since
he wants a database, i have to build it like that.
I have the pieces(raw file uploading into database, now i need to find a way
to export that data onto a
pre-made spreadsheet (columns already there) and the last 3 rows are the
comment fields). Once
all data is completed, there should be an upload button to upload all that
data back to the database, but
to different tables, all depending on the comments. comments will be a drop
down field. (spreadsheet is already made)

Also, since there is 3 warehouse, in the raw fiel, there is a loc field,
that will determine which files
to send the excel sheet to.