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 / December 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
expressions parentheses do they calculate first13 Dec 2005 00:41 GMT1
if you add parentheses to an expression does that calculate it first?
Importing Fixed Width Text File12 Dec 2005 21:34 GMT2
I have a file that is text and I wish to use the Import wizrd, the file is
of a fixed width type, once I have defined that number of characters per
column once, is it possible to automate this so I can import further files
without having to set out the widths again.  Thanks
Need to convert multiple tables into a flat file for Word merge12 Dec 2005 17:31 GMT3
I am a student working for a university library in the production of a
directory of private foundations in our state.  We need to generate a large
directory of these foundations using MS Word (2003).  However, the data for
the foundations has been stored in multiple tables in ...
Export query results12 Dec 2005 17:03 GMT2
i'd like to export the query results in an excel file in a give spreadsheet.
I'd like to have a prompt that asks me where to put the file and what name
to give to it.
Now I'm working with
Importing csv files12 Dec 2005 04:23 GMT2
I have a method for the simple job of importing a csv file, however on
occassion one column starts with numeric values and other times alphanumeric
data
It there a way to force Access to see all columns as text values as a pose
Bug? Export to text file drops numeric data right of the decimal10 Dec 2005 21:52 GMT3
I am trying to do a simple table export to a text file in Access 2003.  The
data has numeric values with multiple digits to the right of the decimal
point (ex: 25.2687).  The data is stored as a number / double.  When I do the
export to a comma demitted file the digits after the ...
exporting to text10 Dec 2005 01:14 GMT1
When exporting a query or a table to text and using file extension of csv
dates get converted wtih format of date/time. Example: 12/19/2005 0:00:00.  
Currently I have to find and replace to correct the csv file.  Is there a way
to automate the export to the correct format?
Linked Table Error09 Dec 2005 21:16 GMT5
I am linking an Excel sheet with a table in Access.  When I link it, it
creates an error table.  When I look up the table, it has 3 fields: Error,
Field and Row.  Under the Error column, it has "Type Conversion Failure"; the
Field column has F2, F3, etc; and the Row column has a ...
Importing numbers from text file09 Dec 2005 17:16 GMT2
I have a text file in which one column contains number in the following
format:
1.000,00. My regional settings are US (1,000.00). When I am importing the
file, the numbers >1000 will not be imported. (I have changed the importing
Error exporting data to text file09 Dec 2005 04:23 GMT1
I am trying to utilized the Export Wizard to export a large dataset (over
100k records) to a text file. I have stored specifications that appear to
work fine, but at the last step, I get the following error:
The MicroSoft Jet Engine could not find the object ". Make sure the ...
Retrieving table information from Test Director09 Dec 2005 04:18 GMT1
I am trying to retrieve some data from Test Director 7.6 and import into an
Access database.  How can I set this process and how would I purge the data
each time I do an import?
Importing Date from a remote user09 Dec 2005 04:17 GMT1
Is there a way in Access to create a questionnaire for use by a person at a
remote site, wherein that user could filling a key field (ID) along with
various pieces of information and have that feed into a main database?
How would the person access this questionnaire, as we want it ...
Change color of font on envelope09 Dec 2005 04:12 GMT1
Every envelope prints in pink. I want it in black. It went to printing pink
and I don't know why and I can't get it to print in any other color. What do
I need to do to correct this.
Make a Calendar09 Dec 2005 04:11 GMT1
I have a simple database in Access with function booking dates, names,
numbers, prices, etc. and want to present and print this data in a calendar
format so I can see at a glance what dates are booked and what are free. Can
I do this in Access or export to Outlook? & how please?
Changing an AutoIncrement Field to a Long Integer Field and Back09 Dec 2005 03:23 GMT3
I realize this is a bit unorthodox and reflects a questionable table design,
but I am coming in on the end of this saga.......
We need to massage a small set of data to get to coincide with an old
system.  In short, the new system uses an AutoIncrement field to assign an
Pages: 1 2 3 4 5 6 7 8 9 November, 2005
 
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.