copy data/drag to text/import to table.

L

LeeTV

Hi,
I am wanting to paste a set of comma deliminted data to a field and click a
button and then have that data imported to my attendees table.

The purpose is to accept email registrations and click and drag the data in
the email to a text box. I tried doing it to a CSV file and then using an
import, but it becomes quite cumbersome having to export the data first then
ensure its in the correct file and import etc. It seems that the would be a
way to paste it to a txtbox and then have access look at the data and import
it.

I am using access 2003.

sample data as follows:

"First Name","Last Name","Street Address","City","State","Zip","Email
","Phone-Home","Phone-Cell","Phone-Fax","Course Name","Course Type","Course
Date &
Time"

The other obsticle here is to strip the phone numbers of any (, - or spaces.
so the resulting phonenumber/s would be 9999999999

Any help would be appreciated.
Thanks
Lee
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

import a text file in to MS Access table 3
Copy and Paste to Import 4
Import files into access 1
Checking if data exists another table and, if yes, extracting a value 0
Word Create a Phone Book using MailMerge in word 2007 0
archiving data 3
How to export table from outlook into ms access table? 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Top