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 / January 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
exporting access v1 data to access 200718 Jan 2008 14:37 GMT3
Is it poossible to export access data from a windows 3.1 program to access
2007?
Signature

Bruce M

truncate zero in the starting when importing from text file18 Jan 2008 12:01 GMT5
I am importing data from text file, it has the field of telephone numbers,
but access truncate all the zeros in the starting. I have set the field type
as Text but still it is not working (although its work when I manually type
data in that field but does not work while ...
link a table using an .ADP access application18 Jan 2008 06:43 GMT1
I am using Access 2003 and have created an .adp, the back end is SQL Server,
I would like the ability to link to a text table located on the network.  I
get the following error when I try to do this.  "You cannot link to tables in
file 'filename.txt' because your Access project ...
Export to a xls-file18 Jan 2008 01:21 GMT1
I have a report in Access which I export to Excel by using the command
"Export" in the Drop-Down-command menu in Access .
In my report I have 5 fields ,let´s call them 1,2,3,4,5 from left to right
in the report
Export field contents to comma dilineated text file17 Jan 2008 22:51 GMT3
I need to export email addresses from a field in a table to a comma
dilineated text file.  What I've been doing is exporting the entire table to
an Excel file, stripping out the other fields and then importing back to
another Access table with only one field and then exporting it ...
Export Data to Multiple XML Files17 Jan 2008 22:03 GMT1
I need to take each row of data from an Access table and export it to a
separate xml file programatically (vba) as there are over 1500 rows.  How do
I do this?
export database to a text file17 Jan 2008 19:02 GMT1
i want to export database to a text file so i can import it into another
database program. i need to export it delimited because fixed width doesnt
work with other database. the only way it works is export to a text file,
delimited, tabs, but then everything is surrounded by ...
Format for Exporting Access data17 Jan 2008 15:38 GMT1
I'm looking for the best format in which to export Access table data that
will be emailed and imported into another Access database.  (Using Access
2003)  From what I've seen, perhaps Excel is the best choice but sometimes it
seems the data formatting is lost in the process.  I ...
how do I download currency exchange rates17 Jan 2008 11:43 GMT1
I am looking for a way to automatically download currency exchange rates into
my Access 2003 database.  I have found an Excel macro that calls a web
service that works great, but I cannot find a similar macro for Access.  I
would like to be able to grab the rates from the MSN ...
Office 2007 Access import failure16 Jan 2008 18:28 GMT1
I am trying to import a 5 million delimited text file into Access
2007.
I get the following:
Error message :
Importing Access query to Excel16 Jan 2008 18:00 GMT3
Using a query from access it is imported to excel file.
For only one user it fails at this line
DoCmd.TransferSpreadsheet 1, 8, "dbo." & QuerySending, SavedName, True,
"InputRange"
Import all related records16 Jan 2008 16:18 GMT6
I have a database with hundreds of customers (cusomer id) with many related
tables.
I have a blank database with the same structure.
How can I  import a specific customer id and all of that customer's
access connections16 Jan 2008 14:40 GMT1
I want to setup access that will have 'screens' where users can enter car
loan application information. I want this information to be saved in access
once the save button has been hit. I want this data to connect to a .net WCF
server and/or a service broker application that is ...
Why do my linked tables not allow me to write to them?16 Jan 2008 10:08 GMT10
I use Microsoft Access to retrieve data from a Sybase database. I used link
table functionality to do this. However, I am unable to write to the
database. If I look at database window under tables and I refer to the column
called "type" the value is "Table: Linked ODBC (Local)" ...
ASCII Import Help 16 Jan 2008 01:32 GMT3
I have some data that comes to me in an ASCII format. Below is a sample. The
trouble is the data ontains double quotes used to identify Inches. But the
ASCII format deliminats using double quote and comas. Is there a way to
control the import so that I don't loose that data. What is ...
Pages: 1 2 3 4 5 6 7 December, 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.