Importing Data from Access

G

Guest

Hi,

Apologises if there is a thread relating to this else where, just could find
it.

I am having problems when I import data into Excel 2000 from Access 2000 and
hope someone can help.
The data appears in my workbook but I am unable to use any lookup on this
unless I F2 and enter on each cell. As the table I'm importing contains
20,000+ rows this is taking some time to complete.
I have tried copying and pasting, using the new DB query wizard in the Data
menu, and formatting the both sets of data to General, Text, etc but nothing
seems to work!
Any suggestions would be greatly received,
Jon
 
G

Guest

It sounds like you might have both numbers and text that look like numbers in
your table. Try entering 1 in an unused cell, copy, then select all your
data and paste special - multiply. It might work.
 
G

Guest

Thanks Michael,

The Data is a mixture of number and text within each cell (e.g H1234) as
well as number only cells which I probably should have mentioned - sorry.
Your suggestion worked for the mixed number/text cells but it caused the
number only cells to square.
Is there any way to prevent this happening or filter the data into 2 columns
1 with number/text and 1 with number?
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
importing/linking data from an Access 2003 Query to an Excel 2003 2
Import Data from Access query 8
Importing Text Files Into Access 1
Formatting with imported data 2
Import data, fill adjacent formulas 1
How to Create a Macro to Import External Data 0
Importing data from excell to access. 2

Top