A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Copying Data into Access



 
 
Thread Tools Display Modes
  #1  
Old February 1st, 2006, 03:17 AM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default Copying Data into Access

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.....
  #2  
Old February 1st, 2006, 06:00 AM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default Copying Data into Access

On Tue, 31 Jan 2006 19:17:50 -0800, "Mike"
wrote:

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.....


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]
  #3  
Old February 2nd, 2006, 08:02 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default Copying Data into Access

The Access-ESP add-in is still undergoing beta testing...;-)

LeAnne
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
cross office program data sharing m_jurrens General Discussion 0 December 16th, 2005 03:36 PM
Microsoft Office should use an advance data crosslinking model m_jurrens General Discussions 0 December 15th, 2005 07:33 AM
PST file has reached maximum size Jeff C General Discussion 2 October 6th, 2005 01:35 PM
Format on data to import to Access tables? (I need your advice) Niklas Östergren General Discussion 5 December 13th, 2004 02:54 PM
Access 2000 -vs- Access 2003? Mark General Discussion 5 November 30th, 2004 06:36 AM


All times are GMT +1. The time now is 07:08 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.