I was asked to import an Excell Spreadsheet into Access and design a
database, but the spreadsheet has more than one workbook, 118 to be precise,
is there a way to get all these workbooks into one Table in Access, I am
fimiliar with the

I have some code that allows me to open a new word document from a template i
have created (see below). i would like to be able to force the document to
have a specific name and location when the user has finished and wants to
save the document.

I am facing problem in importing text file to Access database using python.
I know that transferText method of MS Access is used for this, but not sure
if it works with python.

I need to create a program that when a user clicks on a button (or anything
that is suitable), the program will import data from a text file and put it
into appropriate fields of a table. This must be done automatically. I am
able to import all lines (i.e., data) from a text file ...

Is it possible to have characters such as / (slash) or . (period) in the name
of the file?  Currently it's giving me an error everytime I name the Excel
file to export into with either of this.  For example I can not name the file
08.19.05data.xls

I have a query with 280,000 records in it that I need to export to a text
file.  When I try to do it, though, I get an error message saying that
Notepad can only hold 65,000 records so I'll have to export the rest of my
records separately.  Is there any way around this?  Thanks.

I have read through all the other posts on this issue and found this:
"In another post, I noticed Ken Snell recommending the following to preserve
formatting when exporting a time column to Excel:
MyTimeField: Format([TimeFieldName], "hh:nn")"

I have used my access database in the past with Word and the Mail Merge
feature, but now I need to use a parameter query to supply the information.
Is that possible? I have tried it, and it never works becuase the query is
not run until in Word, and then it doesn't know how to do ...

Hi, I have a date field in a table calles tblFire. I want to export the year
part of this date (eg. 2005) to excel and have this formated as a number.
Currently I'm using this query:
SELECT Format(Date, "yyyy") AS Year FROM tblFire

I have a query that I need to export to a fixed format text file, but when I
try to do it, I either get an error message that says my data is not
updateable or nothing happens at all.  Any suggestions?  Thanks in advance.
Janet

Running a maco that transfers spreadsheet to Excel Template and some of the
data in the memo fields is not exporting.

Thanks for taking the time to read my question.
My DB was in 97 and it works perfectly.  My company changed to 2000 and now
one part of the DB doesn't work.
I am linking 2 external text files to the program.  They are text documents,

I am importing a spreadsheet from excel into an access database. Once in
access the data in this table needs to have individual numbers(example ticket
numbers that cannot be duplicated). This will be a continuing process, so the
number will need to alway be increasing.

I have a Table called TableField that has the table names, fields and
Data type of all the tables and fields in the database.  They are set
up as follows:
Table: TableField

I cannot import all data in an Excel file into an existing table in Access.
The error msg says that 0 records were deleted & 0 records were lost due to
key violation. When i ignored this msg and proceeded with import, some
records were missing. I couldn't identify any ...