Paste tab delimited data into separate fields

  • Thread starter Thread starter Chris Moore
  • Start date Start date
C

Chris Moore

Access 2003 on Vista. I've got an application that provides me with a row of
data in a tab delimited format. Such as:

data1 data2 data3

I'd like to be able to copy/paste that data directly into an Access table
with corresponding data1, data2, data3 columns and have each piece of data
"land" in it's appropriate column. Is there any way to do this without using
an import wizard? Thanks.
 
Chris

At one point (I seem to recall) there were issues with how that kind of a
copy/paste worked (?formatting, ?something).

An alternate approach might be to link to the tab delimited file, then use
an append query to load the data into the appropriately normalized Access
tables.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Works perfectly in Excel but not Access...

Jeff Boyce said:
Chris

At one point (I seem to recall) there were issues with how that kind of a
copy/paste worked (?formatting, ?something).

An alternate approach might be to link to the tab delimited file, then use
an append query to load the data into the appropriately normalized Access
tables.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
 
Yah! But Excel is a spreadsheet and Access is a relational database ...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Suddenly it's working. Seems that you just have to highlight the whole row
and then paste. Thought I tried that before but maybe not...
 
Hi Chris,

Paste Append (on Edit menu) is what you want. No need to highlight a
row.

Clifford Bass
 
Yes - highlighting the row is part of the process.

If you wish to paste into a new table - you need to delete all but the first
row, then highlight the first row and paste, otherwise the data being
imported will be limited to the number of columns in the default new table.

Gordon
 
Back
Top