I am trying to creat a Table linked to Excel and it all goes well according
to Access but when I look at the values in one field I see
ItemCode
#NUM!

The import or link wizard has a data type selection check box that is dimmed.
This should be activated during a data link with excel. This is to force
Access to accept the data type of a field as text, if some of the data
contained in the column is numeric. The wizard dos not ...

Is it possible to convert Pagemaker files to Publisher formatted files.

I am having a problem importing an Excel spreadsheet into Access.  The
columns that im having problems with contain product ID numbers... the ones
that I have a problem with have dashes in the order number.  The import
wizard wont let me change the data type for this column... it ...

Hello, I currently have a table which lists all staff, I also have an Excel
spreadsheet that contains the number of hours that each member of staff works
each week. I would like to use the data in the spreadsheet to update a new
"hours" field in the database, how can I do this?

I am trying to build an import routine to handle the import of data from an .
xls file. I am interested to hear feedback from people who have already
tackled similar challenges. I'm not necessarily looking for full answers
(whilst it would be nice it's not for you to do my work) but ...

I have this annoying problem when linking Oracle database tables via ODBC to
an Access database. The decimal dissapears: 115,12 becomes 11512.
On another PC next to me there is no problem?? Hope someone can help me with
this.

I have been creating queries dynamically in VBA.  Up until now they have all
been Select, Append or Insert.  I recently created a SQL Pass through query
through the front-end and now would like to create it dynamically in VBA.  
What command(s) tell the system that the sql creates ...

I have an ASCII file that originated on a VMS system.  I have tried
transferring it to a Windows system using FTP, specifying type ASCII.  I have
also tried reading it directly from an NFS directory.  I get garbage when I
try to import the file into Access.  I think that Access ...

I have some data to share with another user and want import a link into their
database of my table.  I want to ensure I can still update my table in my
database but prevent the other user making updates to it when they link to it
- is this possible?

I have a database where two tables have a one to many relationship defined
where a single record in table one can have any number of records in table 2,
although in reality it is usually between 1 and four.
I need to export the records to an ascii file where the records are

I have a procedure that scans a specific folder and imports *.xls files (over
60) into my database. The import works fine except that “sometimes” some of
the resulting tables are not in the same sequence as the original
spreadsheet. If I import them manually using the wizard, ...

I have set up a macro which uses the Transfer Text action.  This will be
used to import a file from a folder.
Is there any way to set the File Name arguement so that it brings up an
Import box which would allow the user to browse the network for the file?

I am trying to join two linked tables ("Job_Transactions" and
"Purchase_Ledger" from a database called Sage 100, it's an English accounting
package) by creating a left join. When I run the query, I receive the error
"Could not execute query; could not find linked table. Table not ...

Trying from the last one month to link from Excel through Database Query (Ms
Query) from a User level secured Database - accessed by a shortcut, and was
not able to do that, Any one know , how to do that, Thanks