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 / July 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
different results w/transferspreadsheet 2002sp2 and 200301 Aug 2006 00:01 GMT5
OK, Same database, same spreadsheet, running on two different XP pro
machines, accessed from a network drive.
I have a macro that includes a transferspreadsheet command.
The spreadsheet is in excel 2000 format.
Able to import but not link tables31 Jul 2006 22:11 GMT2
Hi there,
I need to create a linked db to edit some backend data held on a sql server.
I can import data via 'Get external data' but am unable to actually do a
link. I get two main errors:
Retrieving accidentally deleted field (lots of records)31 Jul 2006 21:31 GMT4
I'm working on sprucing up this database, and everything has been going well
until I accedentally deleted the wrong field.  I didn't think it would be a
big deal- I could just use an append query from my backup.  But things have
not proven to be so simple...
Type conversion failure31 Jul 2006 20:53 GMT2
I have a brand new - blank - db table to which I am trying to import an excel
file.  Most of the data are numeric, but I have the field type set to text
because a select few do have a single letter after their 4 digit number.  It
is these 8 alpha-numeric rows that is giving me ...
Convert Existing Full Name Data > Seperate First & Last Name Field31 Jul 2006 20:36 GMT3
Is this possible, have a list of records where their full name is in one
field, covert all those records so their name is split up into two fields,
first & last name?
Thanks
how to; transfer a data base from excel to access office 2003 stu30 Jul 2006 16:25 GMT1
I recorded an assignment in Excel and I should have done it in Access. Does
anyone out there know how to transfer the whole thing to Access. I have till
the end of the day to accomplish this or my grade will bejepordized
tremendously.
import  yahoo address book30 Jul 2006 06:50 GMT1
Can recieve messages form yahoo, and send.  But can't import my yahoo address
book.
created the csv vile per yahoo, and it is on my desktop.  but when I try ot
import get: Translation Error.  a file error has occurred in the csv
Exporting with Range?29 Jul 2006 18:39 GMT2
I'm wanting to export a table to an excel spreadsheet, but putting the data
in a location of my choosing.
TransferSpreadSheet help says you can not use the range on an Export.  
However, I did a search here and someone said that it would work.
Import ODBC Database using VBA28 Jul 2006 19:30 GMT1
I want to import a DBF file (which is created by Foxpro 2.6 for Dos that
have a MEMO field), via FoxPro ODBC, using VBA. For example: Import
C:\dbf1.DBF to Table1 in DB1.mdb by clicking Button1 on Form1. I hope this is
clear (since English isn't my First language).
Transfer table to fixed length text records28 Jul 2006 18:34 GMT5
I have a table the consists of two fields that together make 300 bytes. When
I export this delimited file to text there appear to be 300 characters.
However when this text file is imported to a well established package, it is
validated for having records that are 300 bytes long. ...
Import while DBF file is in use28 Jul 2006 00:58 GMT4
Is it possible to import a DBF file while it is opening (in use) by another
program (such as Foxpro 2.6) but have no access - I mean the records have no
change. Because the DBF files are in use almost the time, and I want to
update everytime I click a button.
Adding a Title Row to Queries Exported in .xls27 Jul 2006 20:22 GMT3
Pardon me if this is a basic question.  I have a query that gets exported to
Excel and am wondering if and how to add a title to the top row of the
exported query.  Any thoughts or suggestions?
Thank you in advance.
Import  date/time into Access27 Jul 2006 20:16 GMT6
I am trying to import date/time information from a .csv file. The information
is in iso format of YYYY-MM-DDTHH:MM:SSZ. How can I get this into a datetime
field of Access. Also, does Access actually store a date and time in a single
field, or must they be broken into a date field ...
How to Import Data Inside the Text Box in Excel into Access?27 Jul 2006 20:13 GMT1
Is there a way to import data from a text box in Excel into Access? I need to
find an automated way to do this because I am doing this task for a large
number of spreadsheets.
Any help would be very appreciated!!
Method 'Columns' of object 'IImexGrid' failed27 Jul 2006 17:29 GMT1
I'm attempting to import an Excel spreadsheet into Access and am getting a
"Method 'Columns' of object 'IImexGrid' failed" message.  What does it mean?
Pages: 1 2 3 4 5 6 7 8 9 June, 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.