I have been having alot of problems in importing data from an excel file into
a current table.  I want to maintain the table structure, with field
descriptions, which is why using the "linked tables" option doesn't work for
me - it doesn't use descriptions.

I've got 200+ excel spreadsheets (.csv) and I need to move them into one
access db to run pivottables.  Excel does not have enough rows.
Douglass J. Steele wrote in a prior message:

When importing a table, I expanded the options menu and noticed the radio
button "import/export specs".  What does this mean?

I would like to put data from one form into 4 or 5 different tables by
opening and closing my reocord set and connection variable in different sub
statements. I'm trying to do this in a control button sub but the control
buttons' sub program does not seem to want to respond to  ...

I'm a relative n00b to access so please be gentle :)
I'm trying to link two tables together.  In order to get aa unique field
from each table I need to concatenate three fields.  Two of the fields are
text, the third is a date (i.e. Field 1 - C111; Field 2- H666, Field 3 -

Using ACC2003 and exporting a query as a xml file. When I do this, the file
looks like this:
--------------------------------------------------------
<?xml version="1.0" encoding="UTF-8"?>

My database links to two tables in another access database and also to
two excel spreadsheets. At work these and the 'main' database are all in
the same folder with other stuff. However I often put this entire folder
on a memory stick and/or copy it to my laptop to work on.

can any body tell me why evry time i turn my computer on i have to do the
time and date and year  in bios
to startthe computer  towork i have windows xp pro.,thanks houshang

I have been working on the Contact Management Database Template for hours and
have never successfully imported data into the Contact Table. This is after
making sure that all fields, columns, formats, etc are identical to the
original.

Can anyone help me with the following problem:
I need to rename a textfile before this is imported into an Access table.
Any ideas?
Thx

I'm new to both Access and VBA.
I have a text file with multiple fields to be imported to access.
But text file does not have fixed width.
Some fields have multiple lines of data. Example:

I have an Access application with linked tables. I am looking for a
way to run the application whithout being connected to the linked
database i.e. when I will run the Access application I will not be
connected to our company network so access will give me an error.

I have a bunch of text in an Access table field named "QDATA". The data
looks like this:
-------------------------------------------------------------------------------------------
<QUESTION DESCRIPTION=""174 - Text 1........."" TOPIC=""topic""

I have a invoice templete in excel 2007 that I would like to use with the
infornmation that I have in a access 2007 database. I cant figure out how
exactly to link the two. Can anyone help

I have several Excel 2003 files that have VBA code in MACROS. These files in
2003 would run in about 2 - 3 minutes. Now they take upwards of 20 - 25
minutes. Any reason why?