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 / June 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Add field data to specific records in table18 Jun 2007 18:37 GMT2
I have a database that gets data from two sources. One source is direct data
entry by me. The other is from Excel spreadsheets. On the spreadsheets, there
are only four fields out of eighteen. (The others are either reptitious or
not needed).
Terminal Services18 Jun 2007 18:36 GMT1
Looking into Terminal services and need to understand how it works, what is
required etc. I am completely new to this and need to know from basic
upwards.
If anyone can point me to pages/sites that has information that would be
export outlook messages and attachments to access18 Jun 2007 18:36 GMT1
I wish to export outlook message content like date, to, from, subject,
message, attachments, importance etc to access database for further tracking.
I am unable to get the date and attachments. Other fields are possible
through the wizard.
Access 2007 importing data with extended character sets.18 Jun 2007 18:36 GMT5
I am trying to move over to Access large data sets.  This data has extended
ascii characters in them like ç, é etc...
The characters are intact in the source data pull (txt file from a SQL 7
qry) but when I import into an Access 2007 table all of those characters get
Error 53: File Not Found17 Jun 2007 16:05 GMT1
I am trying to export records to a txt file.  I got the errot "Error 53: File
Not Found" between these lines
   DoCmd.TransferText acExportDelim, , DocName, STRINGFOLDER & STRINGFILE &
TEXTEXT, True, ""
Transfertext question15 Jun 2007 22:10 GMT3
I have to export some tables for a data warehouse. At first they told me a
CSV file would be ok but now they tell me they need the output with fixed
length columns. And the lengths of the columns must not change from export to
export. Is this going to be possible? There are text ...
How do you print an import specification?15 Jun 2007 15:24 GMT2
I created and saved an import specification.  I want to print this
specification out as my "file layout" document.  Can I print it or cut/paste
into another document?
Export to an already setup excel spreadsheet where columns<>14 Jun 2007 16:51 GMT9
I'm in a jam.  I've been handed something to do that I haven't done before
and have to have it finished tonight.
I have been given an access db with three tables.  I need data from those
three tables and then I need to export the results to an excel spreadsheet.  
odbc--call failed14 Jun 2007 00:19 GMT1
i have an access application that uses linked tables.  try to run a query
using these linked tables.  Sometimes get error  ODBC-call failed.  Works
sporadically.  Any ideas how i can fix so do not get this erro??
thank you so much
Auto Remembering File Names13 Jun 2007 23:25 GMT2
Being new to Access, I'm trying to setup macros to import text files, one at
a time, into access using a specified format, then immediately output them in
Excel format.  However, each text file has a unique name which I want to use
in the name of the output file.  Unfortunately, ...
linking to excel table - problems with data type13 Jun 2007 05:31 GMT2
I'm trying to create a project that requires I link to data in excel.  My
problem is that when I link to the spreadsheet, some of the properties get
set up as number instead of text.  As a result, (at least I think this is
why) my query on this spreadsheet doesn't return all the ...
How to merge 2 tables with the same field names to form 1 querie12 Jun 2007 22:02 GMT1
I have exported two tables from Visual Cactus in DbaseIV form and I want to
import them into Access so I can Querie the combined data.  How can I do this
in Access without first combining the data in Excel????
import excel file into access and keep leading zeros for data 05212 Jun 2007 20:55 GMT1
I am trying to import an excel spreadsheet into access.  We have columns that
have leading zeros (0521) when I import the file it drops my leading zeros.  
Is there a way to keep the zeros when I import the file?
Thanks,
Scanners, Barcode & Peripherals in general12 Jun 2007 16:49 GMT5
I guess this comes under the category of import - though not really....
I have gotten several separate inquiries about using a barcode reader to
ease/speed data entry.....or a magnetic card swipe in a different scenario....
The database size is comfortably within Access's abilities ...
Search key was not found in any record12 Jun 2007 11:30 GMT2
I'm using MS Access 2003.  When I imported a text file in an existing
database, it came up with an error msg "Search Key not found in any records".
I tried to import the same text file in a new database, everything ok so I
assume the text file itself has no problem.  I also ...
Pages: 1 2 3 4 5 6 7 May, 2007
 
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.