Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Importing / Linking / April 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Q&A Import .asc missing data28 Apr 2006 18:43 GMT2
I have Q&A Database (DOS Version) that I need to get into Access. I have
exported it from Q&A several times using different formats. Each format has
its problems but I have most of the data in Access. However one field is
truncated for some records but not others.
error updating excel data from access28 Apr 2006 18:26 GMT2
I just applied the upgrade to Access 2003 and now the linked spreadsheet that
I was updating via a query is no longer editable.  I have tried creating a
new link to no avail.  Does anyone know what might be causing this?  It was
working in the earlier version of 2003.
How Do I Export Integer Data And Maintain Leading Zeros?28 Apr 2006 16:11 GMT1
I've just created my 1st access database.  I have several integer fields that
need to maintain leading zeros when exported to a CSV text file.  For
example: I have created these fields as integers with a format of "00000000".
When I look in the Access tables, I will see a value ...
Link to MS Project File28 Apr 2006 10:09 GMT3
I am aware that you can save a MS Project file as an MS Access MDB but
is it possible to link to a MS Project file from within MS Access.
I am aware that MS Project can link to access but can it work the other
way round?
Linking Access 2002 to Oracle 9i28 Apr 2006 07:38 GMT1
I am using Microsoft's ODBC driver for Oracle.  When I try to link to Oracle
I get a listing of available objects, but an error message when I try to
complete the link.  The error message indicates "There are several tables
with that name.  Please specify owner in the format ...
Can Access export to Excel as a read-only file?28 Apr 2006 06:59 GMT1
I need to export query results from a database using a Visual Basic module to
an MS Excel spreadsheet, and have that spreadsheet 'read-only'.  Is this
possible?
Thanks,
access tables linked to excel files won't update.28 Apr 2006 06:49 GMT4
I have updated the data in an excel worksheet.  I have used the linked table
manager, as well as importing the data, but the new data does not show up in
the access tables.   HELP!!
Importing Word form data to Access28 Apr 2006 06:46 GMT3
I'm trying to get data from a Word form (using form controls/bookmarks) but
can't seem to get the code quite figured out. Now I'm getting error 3265...
Please help. Thanks.
Richard C.
Problems with the Transfer Text Macro27 Apr 2006 13:18 GMT1
I've got a text file that I need to import into access. It imports fine with
the wizard, but I've tried to set up the Transfer Text macro and I'm having
problems. One one run of the macro it reduced the table to one feild with all
of the data jumbled into it. Subsequent runs give ...
Importing Variable column Spreadsheet to Access27 Apr 2006 13:00 GMT2
I have a spreadsheet that has the first 4 colums the same every month but the
next 20 to 30 columns very in number. How do I upload this into access and
attach the relevant code to each column then load to a table with 6 fields?
I have a table listing all the column headings with ...
Mixed exporting27 Apr 2006 05:45 GMT2
I have a vendor that needs a report exported from an accounting system to a
tab-delimited text file. I will used Access via ODBC to do this, but the
vendor requirements show that there are two sets of record types in the
single exported file:
where is data stored?27 Apr 2006 04:53 GMT3
can anyone tell me where the data for a particular database is stored in my
computer?  is it stored within the .mdb file such that if i opened that file
on another computer with Access, all my data would be there also?  or is it
pulling the data from some other place hidden in my ...
Local database with ODBC interface27 Apr 2006 03:06 GMT8
I am trying to create a local copy of an Oracle database to be used by an
antiquated application.  It communicates via an ODBC interface.  I'm thinking
that I can re-create the tables locally (through Access), and setup some sort
of ODBC scheme.  First off, is this feasible?  ...
How do I display values as text (1 = One)27 Apr 2006 01:46 GMT1
I am writting a program in Access that links to Word.  To print checks I need
to find a way to display the numeric values as text in words (i.e. 1 = One or
1032.23 = One thousand thirty two and 23 cents).  
I figure that this is either realy easy and I am completly missing it or ...
Linking to ODBC File dsn26 Apr 2006 23:41 GMT3
When I try to change the file from Access ot ODBC in the Get External Data
link dialog box the dialog box disappears and I can not select the file I
want to. Has anyone had this problem or do any one of you have an idea where
I can start looking?
Pages: 1 2 3 4 5 6 7 8 9 10 11 March, 2006
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.