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 / New Users / February 2006

Tip: Looking for answers? Try searching our database.

Copying Data into Access

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mike - 01 Feb 2006 03:17 GMT
Is it possible to copy Data into access directly such as this

Name    Mike
Address 3333 heldfer lane
ss# 111-11-1111

The data has the header as well and i want to copy and paste and dump it
into Access and let Access sort it all and spit it back to me the way I would
like.  I have 3,000 emails to do this with.....
John Vinson - 01 Feb 2006 06:00 GMT
>Is it possible to copy Data into access directly such as this
>
[quoted text clipped - 5 lines]
>into Access and let Access sort it all and spit it back to me the way I would
>like.  I have 3,000 emails to do this with.....

How consistant is the data? How many fields? Does each entry have the
same number of fields, or do they vary?

You will at the very least need some VBA code to read and parse the
data into an Access table.

                 John W. Vinson[MVP]    
LeAnne - 02 Feb 2006 20:02 GMT
The Access-ESP add-in is still undergoing beta testing...;-)

LeAnne
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this 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.