I have a database, and each month have to import from an excel sheet (set up
specifically for the import) into a table in Access.  Have had no problems
until this month and now I get "Active X cannot create object" and then the
import cancels out.

I need to export an Access 2007 table to cvs format but it doesn't seem
to be available in the export menu. Any way around this?
The import of the other program only supports cvs or vcard.
Thanks,

I have Access 2000 and Access 2003 and neither of them will work.  I have
different databases that I export from or import into, all of which had been
working the last time I worked in them. Now none of them work.
I get the error "Active X component can't create object"

I've created a database that will take large quantities of delimited text
files and import them to Access.  Everything is working fine but I'm
wondering if there's some code that would change the file extension before
importing?  The files are all text but they come to us with a  ...

I have a table containing 885,000 records with 116 sub table identifyers, but
without a field that can uniquely identify each of the sub tables. When I
import the data for this table I have a key field auto generated to uniquely
identify each record as identified below:-

Hi, maybe someone can help me with the following: on a weekly basis I
need to import 3 Excel files into an existing empty table (I run a
delete query on this table before the import). The Excel files are
stored in the same folder every week. Each file has a field showing

I've got a large number of text files (one per week).  They are huge and I
only want to import records where a field is equal to a set value.  If I
imported all the data from a couple of weeks it would break Access.

I have some calculations in a query; one of them is:to_adj_GL_CEQ:
([adj'd_gl_ceq]+[adj'd_optex_ceq])*[Me_fx_rate]
Can you please tell me how can I export this formula into Excel? - not the
result - formula itself? is that possible?

I am importing data from .xls to .mdb
One of my columns in .xls is a date field where the contents of the data
respect the format yyyymmdd but it specified as "number" format in .xls.  So
for example today's date would be noted as the number 20071029.  Note also

i've tried to get on this but it would not let me use my hotmail.com e-mail

Getting the following error message when trying to important a table
produced by a union script (SQL) someone made for me on Friday.
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 10.
SELECT "CSRV131" As CSType, Count(HEALTHCHECKS.Reviewer1) AS ...

I would to import one 03 database into another 03 database and apend the data
into each existing table. I useing Access 2007
I tried the import function however it imported each table into the database
as a "new" table. That is the original table named tblcourse now I have two

In my database I have two tables (Jobs & Files). I have a form (Jobs) with a
Subform (Files) where most of the data is entered.  I have a one to many
relationship (Jobs(1), File(many)) using the Primary Key in "Jobs"
(JobNumber) as a Foreign Key in "Files".  Some of the data ...

Hi - I import a text file which is saved as text and i need to convert that
text field in the table to a number field. Is it possible.?

How can I move my address book from my Live Hotmail MSN account to Outlook so
they become the contact's list?
Thanks, Thomboy