paste a table into a cell

Im trying to copy many tables from a website and paste each one of them as a single piece of information in my database table, each table for each cell,

Ive tried the simply copy and paste in a cell with format Memo and the format of the table is lost, I know that I can make it an image and attach it to each cell but that will make my database huge and slow

Sponsored Links:

Related Topics

Paste a table into a cell
I'm trying to copy many tables from a website and paste each one of them as a single piece of information in my database table, each table for each cell,

I've tried the simply copy and paste in a cell with format Memo and the format of the table is lost, I know that I can make it an image and attach it to each cell but that will make my database huge and slow


Pasting to Excel at a certain location?
I have a table (tbl1) and I want to transfer the data from that on to a template spreadsheet(spreadsheet1) which has headers etc already visible on the top.

I appreciate that its easier to use outputtoexcel etc but ive been told I have to use this spreadsheet to send my data on (lawyers eh?!)

I can create a new spreadsheet and paste the data across but what im wanting to do is automate the process, paste the info, send the email with attachment etc.

The bit in struggling with is how to get paste the info from my table to a certain point in the spreadsheet, cell A8 would be the starting cell I need to paste from.

Also if possible if we could do this with out the field headers from the table that would be brilliant if not I can write in a way of deleting the header line using a WITH function (I think, if im wrong here please point me in the right direction


Import single cell from excel
I need to import a single cell from an excell spreadsheet and place it into a textbox on an access form, I understand the easiest way to so this would simply be to cut and paste.

but here is the crux of my problem I need to do this for multiple cells and paste into multiple textbox's for data that changes on a daily basis, and essentially on the click of a command button.

I have attempted to use the TransferSpreadsheet method but I believe I can specify a range of cells but not a single cell,

In a nutshell I would like to replicate my spreadsheet in access by mapping each cell to a textbox


Import single cell from excel
I need to import a single cell from an excell spreadsheet and place it into a textbox on an access form, I understand the easiest way to so this would simply be to cut and paste.

but here is the crux of my problem I need to do this for multiple cells and paste into multiple textbox's for data that changes on a daily basis, and essentially on the click of a command button.

I have attempted to use the TransferSpreadsheet method but I believe I can specify a range of cells but not a single cell,

In a nutshell I would like to replicate my spreadsheet in access by mapping each cell to a textbox.


Filter time shows wrong result, bug in Access or Excel?
Have a table in Excel 2010 with a column formated as hour:minutes:seconds (00:00:00). First row is 00:00:00, second 00:00:01, and so it continues to 00:05:00.

Have a table in Access 2010 with a field formated as date/time, hh:nn:ss. Copy column from Excel and paste into Access.

When doing some filtering in the table (right click in the first cell "is like 00:00:00", But when I try som other, I.e. 00:00:04, access won't return any result.

I have tried on several pc, and several versions. But I think Access or Excel must have a bug. I can override the problem by choosing paste as special, and choose paste as text instead of paste as excel


Cell Counting? Is that what you call it?
I have a cell in a column B1:
MJTB1001

I need to paste to approximately 235 new rows in the column B1 as follows

MJTB2002
MJTB3003
MJTB4004. etc.

What formula should I use to accomplish this task?

Also I have the cell MJTB2044 and I need to make 235 new cells in column to fit like this.

MJTB2044
MJTB3044
MJTB4044
MJTB5044 . etc. until the middle B5=B235 etc.


Filter time shows wrong result, bug in Access or Excel?
Have a table in Excel 2010 with a column formated as hour:minutes:seconds (00:00:00). First row is 00:00:00, second 00:00:01, and so it continues to 00:05:00.

Have a table in Access 2010 with a field formated as date/time, hh:nn:ss.

Copy column from Excel and paste into Access.

When doing some filtering in the table (right click in the first cell "is like 00:00:00", the query shows the result ok.

But when I try som other, i.e. 00:00:04, access won't return any result.

I have tried on several pc, and several versions. But I think Access or Excel must have a bug.

I can override the problem by choosing paste as special, and choose paste as text instead of paste as excel.


Multiple record paste
I'm sure this has been asked a hundred times, but I cannot find a good answer. In a table, I am trying to copy paste from one field, one record (cell), into multiple records of that same field or any field I wish. Basically, I would love to highlight any range, whether it is single or multiple records and rows, and paste over where I choose. So if in records 1, 2, and 3, I highlight and copy the values in field A, how do I paste these values in records 4, 5, and 6 of field A, B, etc. I know I'm thinking in Excel mode, but I generally do not manually input my data in Access, but rather dump reports through Monarch


Importing cell notes from excel
I have a lot of data stored in cell notes in excel, I need to get these into access, its only 2 fields worth in access, but I need access to realise that new data on a new row in the comment means a new row in access. For example:

(cell comment):

(Access table):
date reading
row 1: 05/03/2009 556,675
row 2: 05/04/2009 557,675

is this possible? There are a few thousand of these that I need transfered over so doing it with copy and paste is taking too long


Return all results in one cell/As one block
I'm saving email address for contacts in a database. I want to send an email to all the contacts and I need the emails to be like one block. That will make it easier by just copy and paste it in the To field in an email.

I've got the data in a table as:
a@b.com;
c@d.com;
e@f.com;

And I need it to be as:

a@b.com; c@d.com; e@f.com

how can I make all results appear in the same cell not as a table


Single Copy and Multiple paste operation:
I observed that when I copy a value, select a range of columns and try to copy in the entire range of cells, the value is pasted only in the beginning cell and rest all are empty.

But I have a requirement when after selecting the range of cells in the table and press Ctl+V the user should be able to paste the values in all the selected range of cells as in excel.

Is there a setting or something in Access for this functionality?


How can i split a cell in query using any one of it's letter
For Example I have a text 2x2.5 in a cell and ineed in 2 in a cell and 2.5 is in another cell.I need to separate by the value "x"


Import Data from Microsoft Excel
Maybe you have noticed that Excel spreadsheets do not always import data very nicely into Access. Sure, Access can import data from various sources with just a few clicks, but Excel files seem to give the most grief. Out of necessity, I created a code module that employs automation to loop through rows of an Excel spreadsheet and systematically add data to an Access table, cell by cell. While this is not exactly a "cut and paste" solution for your data import, it does provide a nice starting point.


Paste Append not working
I've recently been forced to migrate to Access 2007 (much prefer 2003 unlike Excel and Word!)

I've got a problem with locking down a database and creating a custom toolbar to Paste Append records. The aim is that the user should be able to manually select and copy records from one table to another via the clipboard. When I add Paste Append it is disabled. When I use Paste, it creates a brand new table and pastes all the records in there rather than the one selected. (Also the user isn't even allowed to see the new table as I have intentionally hidden all extraneous windows and functionality). So.at present, I've had to leave the users with instructions to use Ctrl-C and Ctrl-V and remove all ribbons and toolbars, which is less than ideal for many users. I want my cut, copy, paste and paste append


Cut Paste Function in SQL Query
I want some suggestion regarding this moving data from one table to another table. Mainly we are using "Insert into table2 select* from table with where condition".

But in this case data moved one table to another as copy paste.

Is it any way to go data as cut paste.


Turning a cell red
I would like to turn a cell red in a query - is this possible or can this only be done in a form or report. I have created a table with medical information and want the cell to turn red when blood pressure entry is greater than 140. Not sure what and where formula should be entered.


Inspect Table and retund a Char. in Access
I am converting an Excel spreadsheet to an Access DB. The Excel sheet has a formula that inspects a quantity of cell for "yes". If yes is found in any of the cells it places a yes in a single colunm (Excel code provided below). How can I do the same Lookup in an Access query?

Excel formula
=IF(OR(,K2="yes",L2="yes",M2="yes"),"X","")

Data lay out
Col1, Col2, Col3 New cell for reslults
Yes, Yes, Yes Retruns Yes in cell
Yes, No, Yes Returns Yes in cell
No, No, No Returns Null in cell


Converting number cell into text
I am unable to have a cell with a number in it to be converted to text ($) in another cell. $1,000 to One Thousand an no/100.

I am trying to convert a number (Dollars and Cents, without the $ sign in the cell, to a text readout in another cell:
$1,000.00 | ( "One Thousand and no/100." ). I tried =DOLLAR ( F5) and it just puts that into the new cell!


OnClick and OnDblClick
I wanna change the particular cell backcolor colour for each record that I selected. As an example if the column name CarNo I put the OnClick event like below

Private Sub CarNo_Click()
ClrRed as Long
ClrRed = RGB(255,0,0)
CarNo.BackColor = ClrRed
End Sub

This works. But how do I maintain the color Red in that particular cell ? The color back to default as I click the next or other cell.
The other thing I wanna do is If on 1st click the cell goes Red, then when I click the same cell again, its color back to default. Is there any way that I can keep the previous and new colour number, let say 0 for default and 1 for red in table for later use?

In Summary
1st Click = cell color turn red
2nd Click = cell color change from red to default


Macro or formula for google map hyperlink
I am attempting to create a formula (macro) with the data setup in the fields below to view in Google maps. I wrote a simple one that works in excel, but will not copy to access. I have thousands of addresses that I need to reference with google map. I would appreciate any help to get me through this project. Thanks in advance. Tom

Cell A Downing (Street Name)
Cell B Street (Street Type)
Cell C 107 (Address Number)
Cell D Buffalo (City)
Cell E New York (State)