I'm trying to import a large .txt file and the data is
fixed width.  The problem is, there is no carriage return
at the end of each data row which is 182 character long.  
It's all just one long string and it's huge.

   With objActiveWkb
       .Worksheets(1).Cells(1, 1).Value = DLookup("F2", "Election Table - Actual File Query", "RowNum = 5")
       .Worksheets(1).Cells(1, 2).Value = DLookup("F3", "Election Table - Actual File Query", "RowNum = 5")
       .Worksheets(1).Cells(1, 3).Value = ...

Can I enter information into an excel spreadsheet that
would automatically update a linked Access Database and if
so, how, specifically can it be done?  
If this can't be done, can information entered into an

I have the master database in Access 2000.  It's linked to
a database of same name in Access 97.  These are on a
server but in separate folders under a main folder
setting.  I've removed relationships in Access 2000 mdb

Is there a way to dynamically change the file names of text exports.  Specifically I have about 200 or so records that need to be exported and I want to put the specific file name at the front of the text file name.  For example the file name is Reel 500 and I want to put that in ...

I am using Microsoft ODBC for Oracle driver version
2.573.9030.00 to connect to Oracle.  When i link to a
table in Oracle from Access 97, one of the fields in that
table is coming up as text even though it is set up as

I have an access XP report that I want the user to be able
to export to an RTF so they can email it to people.  One
of the fields is a memo field.  I try to give it as much
space as possible, but the data still gets cut off and the

I'm importing data from Excel that has been gathered from
several different laptops into a Temporary table in
Access.  The data structure is all the same and filename
is the same.  When the data comes in, I want to set

Hi NG
I'm desperately need to link some free foxpro tables
into my access 2000 application.
Here is what I did:

Is it possible to save/import the import specs you saved
in a database and use them in another database.

I'm attempting to open a newly created excel worksheet
that was created with an Access macro.  I can't open
Excel to that XLS spreadsheet using the RunApp command in
the final step of my Access Macro.  Any help is

I have to export reports to RTF format all the time. The problem is it cuts
off header or data for no reason. And it exports differently from different
machines! It's very frustrating cause I have to consistently check before I
tell users. Even I fixed this time, it doesn't ...

I need to create a file from MS Access 2000 that will place EBCDIC/Hex values in the output record.  This requirement is based upon the fact that the output file feeds into an IBM mainframe.  I need to send high-values and low-values in the output record but can't seem to find a ...

Am using Transfer Spreadsheet command in a macro to update
an Excel spreadsheet. I can get it to work if I update a
spreadsheet with only one worksheet, but I can't figure
out how to update a specific worksheet in a spreadsheet

When I import data from an Excel 2003 spreadsheet into a
new Access 2003 table using File,Get External Data, Import
the wizard will not let me specify any field options
except for the first column. You can click on other