Import Data

G

Guest

Hello,
I want to import data in excel worksheet. I start from Data,Import External
Data, Import Data, Select data Source-"Open",Text Import
Wizard-Step1:Delimited,Step2-Delimiters-Space,Step3-General and Finish. Then
"Import Data"-Existion worksheet (=$A$1). Before import of data appear" !
Microsoft excel "Message"-The text file contains more data than will fit on a
single warksheet .To cantinue and import as muchof the data as will fit click
OK. You can than import the rest of the data by repeating the import
operation on another worksheet and using the Text Import Wizard to exclude
data already imported."
I tried but in every worksheet are the same data.How I can import a rest of
data on another sheet or worksheets ??- IT is Not EXplained!!!! (my data has
1405 columns and 621 rows)
 

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
How to exclude data that has already been imported? 1
Importing Text Files Into Access 1
text file contains more data than will fit for a single worksheet 1
How do I import data from 1 excell workbook to another? 1
Text Import Wizard (use for large files) 2
Import old dos sequencial data 3
How do I import data in Excel 1

Top