I was having a problem with importing .dat files and Jeanette Cunningham
graciously helped me figure it out.
The code is working perfectly to automatically import the .dat file at the
push of a button.  The only problem I'm having now is, when the file is

I am working on an Access 07 database, and I must say, it has some really
cool bells & whistles, like the Data Task window.  I have three import tasks
in here that I would like to add to a macro or automate somehow.  I see I can
do this from Outlook, but I need it to happen after ...

I'm currently looking for the best way to import information from
several 2003 and 2007 Access databases into a single 2007 database.  This new
databse will act as a company dashboard summarizing statistics from all other
db.

Is it possible to Export an Access 2007 report to Excel?  It was so easy in
Access 2003 to just go to Office LInks > Analyze with Excel. Is there a
comparable feature? The only way I can find is to export as an xml file.
Excel is not an option. Then you have to open the file as ...

I am using Access 2003 on Vista Ultimate.  I have imported 15 or so large csv
files without problem.  Then the import text wizard failed throwing the
following error “An error occurred trying to save import/export specification
‘filename’”.  I did not try to save the export ...

I need to import daily excel worksheets into 1 access file and then
compare/count the records.  Is there a way to do this?  Thank you

I am trying to import a Fixed Width, text file called ERSCUST.dat into Access
(2000).  
I am not able to import the .dat file, I get the error message “Cannot
Update.  Database or object is read-only.”  Once I change the extension to

I am trying to import a 200MByte delimited text file into a new Access
Database.  The Import Wizard has been running over 1 hour, sucking up 100%
CPU on my laptop and has yet to open a window.
I've imported much smaller files before without any problems.  Is this

I have a comma delimited file that has a ," after the last record on each
row.  When I import, I naturally get unparsable record error.  Any ideas to
work around this?

I use excel data tables that link into Access databases. Am only just moving
from Access 97 to Accss 2003 and there is a problem with links for any
spreadsheet tab that has a name which includes any space or other non
alphanumeric characters it seems. The links do not work any ...

I have a query with this statement in some SQL:
Format([T1].[V]*[T2].[V2], "Currency") AS [Value].
When I export the query to Excel, the Value field is exported to Text, not
to a numeric Number type.

I have several Excel files all with extremely different data, but having a
common identifier, that I want to import into an existing Access database
that contains the identifier.  These are huge files.  I realize that the
field names need to be identical to those in Access.  It ...

I' d like to insert data from MS access 2000 table to mysql table with utf8
character set. Problem is, that access table has a different character set
(coding) then utf8. Is there a way, how to change between character sets?
SQL statement character set does not work in access.

My present database seems to have lost all of the import specfications, about
20 of them, used to import .txt delimited files.  My backup copy of the same
database has all its import specifications.  What system object(s) do I need
to copy from my backup database to the present ...

At the moment i use the following code to simply export some data from my
access form to my word template and fil lthe appropriate gaps...
e.g.
doc.Bookmarks("JobNo").Select