Tech Problem Aggregator

Excel import file with ETX symbol

Q: Excel import file with ETX symbol

I import a text file into Excel and have a macro to change it from a fixed width file to CSV. The file now has as block character at the end now, which I believe is the ETX end of text character. I need to write a macro to delete this so the CSV file is readable by another program.

Does anyone know what Excel translates this character as?

A: Excel import file with ETX symbol

7 more replies
Answer Match 69.72%

I'm trying to open in Excel 2010 a file with .exf extension that is always a pipe delimited text file. I have set, using Windows file associations, to open this type of file with Excel. But, I would like for it to recognize that it is pipe delimited, so that I don't have to click on Delimited, Other, "|" to import the file. Any ideas? I also thought about using a macro to save some steps as well. Thanks for your help!
 

A:Excel import pipe delimited file based on file extension

Hi, welcome tothe forum
Macro is the solution, just start the macro recorder, give it a name and do what you do, stop the recorder and you have the macro.
Simple as pie
 

3 more replies
Answer Match 68.04%

I have a large document saved in Word Perfect 12 and I need help importing this data into an Excel speadsheet. Any suggestions?
 

More replies
Answer Match 68.04%

When trying to import from Excel I don't have the option as the instructions say under Help to "Import from another program of file". I have 3 options which are: "Export to a file", Import Internet Mail Account Settings" and Import Internet Mail and Addresses. Can anyone help direct me, this seems simple but I am stuck.

A:Import contacts from Excel file

What email program are you using?

7 more replies
Answer Match 67.2%

Hello,

I reference an object (Monarch) to create a table that I then want to import into my Access Database. The file is outputted by default to a .xls extension and Microsoft Excel 2.1 Worksheet (I am using Office 2003). When the below command runs, I receive an error indicating that the file is not in expected format. I have tried all the "TypeExcel#"'s and haven't had any luck. Any suggestions?
Code:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblVendBO", strExportTable, -1
I also tried to rename the file into a .tab file, however, when I import that file, it is all jibberish.

Thank you,
Roger
 

A:Solved: Excel File won't import into Access

7 more replies
Answer Match 66.36%

Hi,
I have multiple .dat(more than 100) files with me . Each contains data as below (sample).

GEN DATE|SOURCE|PRODUCT|STRIP|LICENCE|LICENCE TYPE|STRIKE|SETTLEMENT VALUE|NET VALUE|RECORDED DATE|PRODUCT_ID
5/07/2014|YEMU Euro BOB OXY FOB Rdam Bg Mini|Abcdfr Futures|10/1/2015|AOM|F||864.946|4.815|11/2/2015|5033
5/07/2014|YEMU Euro BOB OXY FOB Rdam Bg Mini|Abcdfr Futures|11/1/2015|AOM|F||858.765|4.715|12/1/2015|5033
5/07/2014|YEMU Euro BOB OXY FOB Rdam Bg Mini|Abcdfr Futures|12/1/2015|AOM|F||856.524|4.79|1/4/2016|5033
5/07/2014|YEMU Euro BOB OXY FOB Rdam Bg Mini|Abcdfr Futures|1/1/2016|FOG|F||860.039|6.172|2/1/2016|5033
5/07/2014|ZEMAL Euro BOB CAR FOB Rdam Bg Mini|Abcdfr Futures|2/1/2016|MIG|F||860.797|4.515|3/1/2016|5033
5/07/2014|ZEMAL Euro BOB CAR FOB Rdam Bg Mini|Abcdfr Futures|3/1/2016|ULM|F||859.065|4.099|4/1/2016|5033
5/07/2014|ZEMAL Euro BOB CAR FOB Rdam Bg Mini|Abcdfr Futures|4/1/2016|ULM|F||898.499|5.248|5/2/2016|5033
From this I want to create a dat file contains data for Licence ULM only.

Anybody please help
 

A:Solved: Import multiple dat file to single excel

12 more replies
Answer Match 66.36%

When I import a Text file into Excel (through Data > Import External Data and go through the Wizard) the data comes across correctly in the right columns etc. - I'm ok doing that.

The numbers and/or currency in my data do not seem to "work" properly as when I try to do calucations (such as a simple autosum) the answer always comes back as 0.

I've tried re-formatting the data as numbers/currency but this doesn't help.

I've also tried multpiplying the numbers by 1 (using Paste Special) to get them to re-format but this doesn't help either.

Any suggestions?

Thanks!
 

A:Import Text file to Excel - number format

Hi there, welcome to the board!

They could possibly have leading and/or trailing spaces. A couple of ways to handle that. Download/install a free add-in called ASAP Utilities, which you can access from (assuming Excel 2003, which is what it sounds like) ASAP Utilities menu, Text, Delete leading and trailing spaces. The range must be selected first. Another way would be to write your own macro to do it. If you don't have ASAP I'd highly recommend it, as it gives you additional tools and resources not native to Excel, making your life in Excel much easier.

An easy way to check would be to use a blank cell (generally adjacent column) and enter the formula =LEN(A1), where A1 references the cell in question with your numbers. No doubt they're numbers stored as text. If you've done the paste special then there's nothing to force to numerics. The other way to do that would be to select everything and to Text to Columns (from Data menu), and just click the Finish button (not going through the Wizard), which will also force (coerce) numerics stored as text to numerics.

HTH
 

1 more replies
Answer Match 64.26%

can download bank statement to excel file and money says the statement has been downloaded, but cannot 'see' the statement or figure out how to get transactions from the statement to the money account check register.
is there a way to get the transactions from a delimited file, or to cut and paste?
akm
ps: i just downloaded the install file/s for a product called 'Big Red Consulting Excel Add-In' for importing excel info into money 2003.
not sure if it will do the job... it creates a qif file from excel, but not sure if it will added the data to to the transaction register.
any ideas on this product?
 

A:ms money 2003... how to import bank statement (excel, etc file) to account register?

akm said:

can download bank statement to excel file and money says the statement has been downloaded, but cannot 'see' the statement or figure out how to get transactions from the statement to the money account check register.
is there a way to get the transactions from a delimited file, or to cut and paste?
akm
ps: i just downloaded the install file/s for a product called 'Big Red Consulting Excel Add-In' for importing excel info into money 2003.
not sure if it will do the job... it creates a qif file from excel, but not sure if it will added the data to to the transaction register.
any ideas on this product?Click to expand...
 

3 more replies
Answer Match 59.64%

Good morning / Good afternoon
As a newbie I am making the first posting on your forum and I hope it is not a silly question.

I received a hard print of an excel spreadsheet with data in 9 columns (2 date formatted and 6 number formatted) of figures from my by bank and I wish 2 use them for further calculation. As I didn't get an electronic file from the bank I scanned the data sheet on the HP Scanner into text files ( rich text, plain text etc) and attempted to import the text into Excel; but I was unsuccessful. Have I attempted the impossible or did I do something wrong ?

If it is possible to do so how should I proceed ?
With thanks, anothernub
 

A:How 2 import text data into Excel from scanned text file ?

12 more replies
Answer Match 57.96%

I'm working on a Bill of Material creation automation project that requires some expertise in VBA, and I have none.
The objective is to run a macro from an excel spreadsheet called "PGE BOM", to do the following:
1) Go to the folder "C:\Documents and Settings\Desktop\Auto Project"
2) Find all the .mdb databases in this folder
3) Find "HistoricalMaterialItemsAll" table in EACH of those databases in step 2, and import the data from the columns listed below into PGE BOM.xls's columns C through G:
DrawingNumber
ItemNumber
Quantity
PgeCode
Description
The following is a VBA code that my friend had written in Excel 2007. Unfortunately I have an older version (2000) and the code does not seem to be compatible with Excel 2000.
Sub ImportAccessData()
Stop
dPath = "C:\Documents and Settings\Desktop\Auto Project\"
sFile = "*.MDB"
strSrch = dPath & sFile
Set TargetWB = Application.ActiveWorkbook
Set TargetWS = TargetWB.ActiveSheet
sRow = 2
bFile = False
If Dir(strSrch) <> "" Then
strFlNm = Dir(strSrch)
bFile = True
End If
Do Until bFile = False
strPath = dPath & strFlNm
Call GetData(strPath)
strFlNm = Dir
If strFlNm = "" Then bFile = False
Loop
End Sub
Sub GetData(fl)
Stop
strSQL = "Select HistoricalMaterialItemsAll.* From HistoricalMaterialItemsAll"
Workbooks.OpenDatabase fl, strSQL, xlCmdTable
Set WB = Application.ActiveWorkbook
Set WS = Applicatio... Read more

A:Excel Macro - VBA code to import access data to excel

Hello, and welcome to the board!

When posting code, please use CODE tags, which extremely helps with readability.

Perhaps you could try using the code constant???...
Code:

Option Explicit

Sub ImportAccessData()
Dim dPath As String, sFile As String, strSrch As String
Dim TargetWB As Workbook, TargetWS As Worksheet
Dim sRow As Long, bFile As Boolean, strFlNm As String, strPath As String
dPath = "C:\Documents and Settings\Desktop\Auto Project\"
sFile = "*.MDB"
strSrch = dPath & sFile
sRow = 2
bFile = False
Set TargetWB = Application.ActiveWorkbook
Set TargetWS = TargetWB.ActiveSheet
If Dir(strSrch) <> "" Then
strFlNm = Dir(strSrch)
bFile = True
End If
Do Until bFile = False
strPath = dPath & strFlNm
Call GetData(strPath, TargetWB, TargetWS)
strFlNm = Dir()
If strFlNm = "" Then bFile = False
Loop
End Sub

Sub GetData(fl As String, WB As Workbook, ws As Worksheet)
Dim strSQL As String, iRow As Long, sRow As Long
strSQL = "SELECT HistoricalMaterialItemsAll.* FROM HistoricalMaterialItemsAll"
Workbooks.OpenDatabase fl, strSQL, 3 'xlCmdTable
iRow = 2
Do Until ws.Cells(iRow, 1) = ""
ws.Cells(sRow, 7) = ws.Cells(iRow, 5) 'Get the Description
iRow = iRow + 1
sRow = sRow + 1
Loop
Application.DisplayAlerts = False
WB.... Read more

1 more replies
Answer Match 57.54%

Hi,

This may seem quite basic, but I am working on an excel model where the formula begins and ends with {}

I was wondering if someone could tell me what the { } symbols do because if these are excluded, the formula gives error.

Thanks.
 

A:Symbol in excel formula

Welcome to TSG. This would have been better asked in the Business Applications forum, however those are set brackets. See here http://en.wikipedia.org/wiki/Table_of_mathematical_symbols for a complete table of math symbols.
 

1 more replies
Answer Match 56.28%

Hello,

I have a file with about 30 tabs and I need to change the currency symbol from C$ to A$ on all tabs in all cells.
There is also US currency in my file, but those are indicated as just $.
For example: $500 C$600 should be changed to $500 A$600
The columns are not identical, therefore I can't select all tabs and columns and format the numbers that way.
Does anyone know if there is another way I could do it all at once with one step?

Thank you in advance.
Fern.
 

A:Change currency symbol on several tabs in Excel

if you goto find
use replace
C$
with
A$
Options > Workbook
it will change every C$ on every cell

is that what you need ?
 

1 more replies
Answer Match 56.28%

I want to insert several Infinity symbols into an Excel spreadsheet, and read that to do so one must use "ALT" followed by 2, 3, 6, and then release the "ALT" key. As I remember it, Infinity looks like a figure 8 turned on its side, but when I carry out the above routine it comes up with a letter like this: ý
Can anyone assist me to find the correct Infinity symbol via my keyboard? (I am using Windows 7) Many thanks.
 

A:Solved: Infinity Symbol in Excel Document

6 more replies
Answer Match 55.44%

ms office excel 2010 symbol not working to insert on page, , all the symbols when you press " insert " symbol and the character box opens.in microsoft excel and word. what might be the issue....

A:Ms office excel 2010 symbol not working to insert on page

Please we need a little bit more information. What symbol? What page?

Kari

1 more replies
Answer Match 54.6%

Hello,

Could you please help me with the following question. I have a simple division formula (=A1/A2) and would like to add a symbol, "x" after that, so the format of the cell would be: 1.23x. My problem is that I can't use & "x" because the format of the number (2 decimal places) no longer holds, and I get something like: 1.234445555x if I use (=A1/A2 &"x").

Could anyone please help me with the solution?

Thank you!

Alexis
 

A:Solved: Excel - adding a symbol after formula and keeping format of the number

This should work for you.

=ROUNDDOWN(A1/A2,2)&"x"
Rollin
 

2 more replies
Answer Match 52.92%

Hi, I was running an antivirus, and I noticed that some of the file descriptions on my laptop had what I think are Chinese symbols in them. should I be worried about this or is it normal?  
 
one of the files was   C:\Windows\Installer\16cd65.msp->#152TTo152U/(chinese symbol)InstallExecuteSequence   there were more but I didn't manage to catch what they were, I took a photo of the screen that I can post if it helps but the symbol is probably to small to read.
 
It was over a week ago when this happened and I can remember if I was running 9labs removal tool or eset. I can't find a log for eset (I don't think it picked up anything) but here is the results for 9lab:
 
9-lab Removal Tool 1.0.0.34 BETA
9-lab.com
 
Database version: 104.31213
 
Windows Vista Service Pack 2 (Version 6.0, Build 6002, 32-bit Edition)
Internet Explorer 9.0.8112.16421
lisa :: LISA-PC
 
18/05/2015 20:25:12
9lab-log-2015-05-18 (20-25-12).txt
 
Scan type: Full
Objects scanned: 39877
Time Elapsed: 1 h 16 m
 
Files detected: 1
[24FE0BB7A85A866B487D15C0EB6E3A74] Malware.Win32.Gen.sm [C:\Users\lisa\Downloads\ninja-setup-3.0.6.exe]
 
I guessing that this is a false positive for system ninja (I was advised to use it from this site last time I had a problem)
 
thanks in advance for any help

A:Chinese symbol in file.

Download Security Check from here or here and save it to your Desktop. Double-click SecurityCheck.exe Follow the onscreen instructions inside of the black box. A Notepad document should open automatically called checkup.txt; please post the contents of that document.NOTE 1. If one of your security applications (e.g., third-party firewall) requests permission to allow DIG.EXE access the Internet, allow it to do so.NOTE 2. SecurityCheck may produce some false warning(s), so leave the results reading to me.NOTE 3. If you receive UNSUPPORTED OPERATING SYSTEM! ABORTED! message restart computer and Security Check should run Please download Farbar Service Scanner (FSS) and run it on the computer with the issue.Make sure the following options are checked:
Internet ServicesWindows FirewallSystem RestoreSecurity Center/Action CenterWindows UpdateWindows DefenderOther ServicesPress "Scan".It will create a log (FSS.txt) in the same directory the tool is run.Please copy and paste the log to your reply. Please download MiniToolBox and run it.Checkmark following boxes:Report IE Proxy SettingsReport FF Proxy SettingsList content of HostsList IP configurationList Winsock EntriesList last 10 Event Viewer logList Installed ProgramsList Devices (do NOT change any settings here)List Users, Partitions and Memory sizeList Restore PointsClick Go and post the result. Please download Malwarebytes Anti-Malware (MBAM) to your desktop.NOTE. If you already have MBAM 2.0 installed scroll down.Double-click ... Read more

12 more replies
Answer Match 52.92%

cannot open
activity log in Norton. this is some of Dr Watson findings:
Application exception occurred:
App: c:\Program Files\Common Files\Symantec Shared\ccLgView.exe (pid=3208)
When: 7/16/2004 @ 22:24:40.671
Exception number: c0000005 (access violation)

ERROR: Symbol file could not be found. Defaulted to export symbols for C:\WINDOWS\System32\MSVCR70.dll -
function: MSVCR70!wcscpy
WARNING: Stack unwind information not available. Following frames may be wrong.
ChildEBP RetAddr Args to Child
 

More replies
Answer Match 52.92%

I want to create a 4 page application form (in word2000)
I then want to have certain fields on each page, but I want the same on each...i,e, when I enter the client's name SS# and some other pertinent info I only have to enter it once but then it should appear on all the pages...I thought I'd keep the list in excel and insert it into word but am stumped any suggestions???
 

A:import from excel

Not sure what to suggest for the best, wdisneymom.

You can insert text form fields with the appropriate button on the Forms toolbar. Then you can add one or more Ref fields (Insert -- Field -- Links & References category) with field codes such as "REF Text1". When you then protect the doc, you can tab through & fill in the TFFs ; the Ref fields will update when you print or print preview.

But if there's much manual editing to do for each doc, it could get messy (with switching between protected & unprotected). Give it a go & see how you get on.

If you end up opting for a "merge from list" approach, I wouldn't recommend using Excel unless you specifically need the info in Excel for other purposes. Just use a table doc file instead.

I expect Dreamboat has stuff on this ; I'll go search.

Rgds,
Andy
 

2 more replies
Answer Match 52.92%

Hello Guys,

Hope you can help me with this piece of code that i'm struggling with, what i want is to import to excel both children's "importe" amounts for each of the cfdi:Trasladado's Parent below, here is the piece of the xml and the vba code i'm using.

XML:
-<cfdi:Impuestos totalImpuestosTrasladados="42.39">
- <cfdi:Traslados>
<cfdi:Traslado importe="9.20" tasa="0.36" impuesto="IEPS"/>
<cfdi:Traslado importe="33.19" tasa="16.00" impuesto="IVA"/>

VBA CODE:
ElseIf Trim(Cells(2, y)) = "/cfdi:Impuestos/cfdi:Traslados/cfdi:Traslado/@impuesto" Or _ ' Code to import IVA importe
Trim(Cells(2, y)) = "/cfdi:Impuestos/cfdi:Traslados/cfdi:Traslado/@importe" Then
IVA = Cells(3, y)
ElseIf Trim(Cells(2, y)) = "/cfdi:Impuestos/cfdi:Traslados/cfdi:Traslado/cfdi:Traslado/@impuesto" Or _ ' Code to import IESP importe
Trim(Cells(2, y)) = "/cfdi:Impuestos/cfdi:Traslados/cfdi:Traslado/cfdi:Traslado/@importe" Then
IEPS = Cells(2, y)

The problem is that since there are two children with the same name it just import the first children's importe and for the second doesn't import anything.

by the way I have a column in my excel worksheet called IVA (column I) and in column L i have the IEPS column so when i run the macro it just import t... Read more

More replies
Answer Match 52.92%

Can I import a Excel file to Access file so I can edit the file then resave in Access?

I have inventory files in Excel but I can only view Excel view 97
I am trying to avoid having to buy Excel.
puter hater
 

A:Can I import a Excel

you can import excel data into an access table (need same fields, field data types etc - gets a bit tricky sometimes) or you can import an excel sheet into access and have it create a table (make sure each excel row1 column has a name in it to be used as a filed name, easier than renaming them in access)

the data can then be edited, saved in the access table, exported as an excel sheet

perhaps try one of the 'open office' type office suites (was star office, forget the free version name)
- should be able to read and change excel data
- access isn't really made for spreadsheet functions alone
 

1 more replies
Answer Match 52.5%

I've had the asian language pack installed on my laptop for awhile now and I know of a similar issue that involves the Korean won symbol, fortunately that never happened to me and I use my computer to type Korean frequently. I was attempting to get a program to run in Japanese to help out one of my friends, and after a restart; anywhere there's a file path it shows the &#65509; instead of \.

I know there's no difference aside from appearance, but it's really annoying to look at it.

I've uninstalled the program and looked around the Regional and Language options, policy settings, and about anywhere I can think of, maybe I missed it somewhere, but I can't find a way to revert it. Can anyone help? Thanks.
 

A:Yen symbol () instead of backslash in file paths.

Shameless bump.
 

2 more replies
Answer Match 52.5%

I have DL'd some freebie stuff for X-plane. [Aircraft - airports etc]
I have used a recommended installer to ensure correct file placement.
None of the new stuff will open in the program although it is itemised.
In WinExplorer each new file has a little lock symbol on the icon.

Can anyone explain this and how to deal with it?

Thanks.
 

A:Lock Symbol on File Icon

I am going to assume the last post in this thread should help you. This is the first thing Google found.
http://social.technet.microsoft.com...y/thread/e6e585dc-c685-4e2f-8c62-db2f762ab056
 

2 more replies
Answer Match 52.08%

Is it possible to import from notepad into excel?

I want to take a list of about 100+ single words from note pad (1 on each row) then put them into an excel sheet.

Problem is that I want to split the words up and insert a translation of the word above each one and then box the pair. I can type the translation manually but it could turn into 100s so I want to find a quick way to do some of it.

It would look like a full page grid with 2 words in each box.

Any help much appreciated
 

A:import from notepad to excel

13 more replies
Answer Match 52.08%

Hi,

how to download or import data from website to Excel automatically? is there any software's for that please provide me information and assist me

regards
satya
 

A:Import data from web to Excel?

6 more replies
Answer Match 52.08%

Im trying to use i believe DAO from an access 2007 database into Excel 2007. The database far as i know was created in Access 2007 on the same server that im trying to run Excel 2007 on and everytime i put in the dang connection string i get an "unrecognized database format" error. This is driving me mad.

I want to read the database and start scrolling through records and pulling in only the data i want into specific cells. I've done this before and never had this problem.

Basically the user will put a date in a cell. Then i want to start reading records and everytime i find a certain value in a cell i need to pull parts of the record into cells in a worksheet, then move onto the next record on that date. But i can't get past the damn connection.

I have the Microsoft DAO 3.6 object library and the Microsoft Office 12 reference and nothing....tried on 2 different versions of excel and i get the same message regardless.

Any ideas hints suggestions.

Code:

Sub CrankUpdate()

Dim db As Database, rs As Recordset
Dim R As Integer, C As Integer

Set db = OpenDatabase("W:\WORK ORDERS 2010_1.accdb")
Set rs = db.OpenRecordset("Talisman")

RecordCount = rs.RecordCount
For R = 1 To 75


Next R

End Sub
 

A:Trying to Import from Access into Excel

I am not familiar with how Excel 2007 talks to Access 2007, but in earlier versions you could either Copy & Past Special Link to a database query or create an Excel Query.
Or you could use DDE (Direct Data Exchange).
 

3 more replies
Answer Match 52.08%

I am new to VBA Macro. I am trying to create a VBA macro to import CSV file to excel. The following is the code that I recorded it, however, I manually finished writing the last part of the code because there was an error saying "Too Many Line Continuations" however, it is not liking it. I am not sure where I did wrong. Some times I get the error message saying statement too complex. It is actually pretty straightforward. The most part is the datatype. The file I am trying to import has about 3700 columns. It would be great if someone can help me out here. Thank you.
Code:

Sub VBAMacroInpatient()
'
' VBAMacroInpatient Macro
'
' Keyboard Shortcut: Ctrl+Shift+I
'
With ActiveSheet.QueryTables.Add(Connection:="TEXT;Z:\Alex\Inpatient.csv", _
Destination:=Range("$A$1"))
.Name = "Inpatient"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.TextFilePromptOnRefresh = False
.TextFilePlatform = 437
.TextFileStartRow = 1
.TextFileParseType = xlDelimited
.TextFileTextQualifier = xlTextQualifierDoubleQuote
.TextFileConsecutiveDelimiter = False
.TextFileTabDelimiter = True
... Read more

A:HELP: VBA Macro to Import CSV to Excel

16 more replies
Answer Match 52.08%

Hello,
I am attempting to build a macro to import a specific range of cells from Excel into MS Access. Is it possible to import the range A3:A7 from excel into column A of access, then the cell A8 into column B. It would also be from a sheet within the excel sheet named "Selected users". The added twist to it is that there are multiple excel files to import from, but the ranges will all be the same.
I know this is a very specific question but would anyone have any VBA code to support this action.

Thank You,
Izzy
 

More replies
Answer Match 52.08%

I have set up a routine to extract the list of accounts and associated costs from Sage to each Account code - this data is then imported into Excel and fed into a worksheet (using simple cell references) the file is updated every time the file is opened.

My problem is that when a new code is entered into Sage accounts and subsequently added into the routine, how can I ensure that my Excel worksheet will include this additional code.

I hope you understand ramblings - I've attached an example of the file as this might be of more use !

Thanks,

Moll
 

A:Sage Import and Excel

6 more replies
Answer Match 52.08%

I am trying to import into access...I go to file,new, get external data...in files of type, excel is not a choice...I do what the instructions say and even have uninstalled and re-installed office 97 only to have the files I need permanently "greyed" out so I can't install them
Is there a way to clean this completely off my hard drive that I must be missing
 

A:import excel into msaccess

6 more replies
Answer Match 52.08%

Hi All,

I have a symbol with 2 blue arrows on all my file icons and i have no idea what it is. Any ideas?

Thanks,
Ed
 

A:Solved: unknown symbol on all file icons

8 more replies
Answer Match 52.08%

When I attempt to compile the file I get this error: "UsingExceptions.java:11: cannot find symbol
symbol : method throwException()
location: class UsingExceptions
throwException(); // call method throwException
^
code
public class UsingExceptions
{
public static void main( String args[] )
{
try
{
throwException(); // call method throwException
} // end try
catch ( Exception exception ) // exception thrown by throwException
{
System.err.println( "Exception handled in main" );
} // end catch
}

public static void doesNotThrowException()
{
try // block does not throw an exception
{

System.out.println( "Method doesNotThrowException" );
} // end method doesNotThrowException
catch ( Exception exception ) // does not execute
{
System.err.println( exception );
} // end catch
finally // executes regardless what occurs in try...catch
{
System.err.println( "finally executed in doesNotthrowException" );
} // end finally

System.out.println( "End of method doesNotThrowException" );
}
// demonstrate try...catch...Exception
public static void throwExceptionB() throws Exception
{
try // throw an exception and immediately catch it
{
System.out.println( "Method throwExceptionB" );
throw new Exception(); // generate exception
} // end try
catch ( Exception exception ) // catch exception thrown in try
{
System.err.println(
"Exception handled in method throwException" );
throw exception; // rethrow for further processing

} //... Read more

A:Error in Java file: cannot find symbol

You don't have a method called throwException();
 

3 more replies
Answer Match 51.66%

I have a SQL query that I pasted into the MS Query ("MSQ") SQL text box and it runs fine an renders the correct data in the MSQ box. When I click the little MSQ icon to have it link up to my Excel sheet it seems to link but when executed in Excel it just sits there. No data. Is it because I have a prewritten query? The link-up doesn't seem to have a problem coughing up data for a whole table if I use their little wizard, but my queries are fairly complex and the wizard is a bit too simplistic. Any thoughts would be appreciated. Thanks!
 

More replies
Answer Match 51.66%

I have been using Access version 2 for many years, importing the same excel
spreadsheet that I update monthly. Lately Access has been giving me an
error message saying the spreadsheet format is bad. I have always had to
store the spreadsheet in an older excel format to allow the import to
Access. I have the same problem with Excel 97 and Excel 2007. I am
running XP with all the current maintenance. Access seems to work normally
( at least for the limited functions I use) other than the Excel import
function.

As further clues, I have only recently begun using Excel 2007, but when I go
back and resave the sheet with the old excel it still doesn't work.

Ed
 

A:Access - cant import excel spreadsheet

7 more replies
Answer Match 51.66%

Is there a way to import a vcard's data into an existing spreadsheet?

I have an excel spreadsheet that we do estimating of jobs. Instead of retyping all info (ie: Name, Address, Cell, Work Phone, etc. etc.) We would like to be able to import a vcard record to an excel sheet.

Thank You,
Michael D
 

A:Import 1 vcard record to excel

I'm sure it could be code some way. you should see it as a text file, not all vcards will contain the same data because they may contain more data if it's filled.
And less if they are not filled.

Have you tried opening one in notepad?

This is what you see

BEGIN:VCARD
VERSION:2.1
N:Familyname;Surname
FN:Surname Familyname
TITLE:Managing Director
ORG:Company Name
EMAIL;INTERNET:[email protected]
END:VCARD

Mind you it's possible that my system uses the ; as a field delimiter and yours a , so you'll have to do some checking

It's a aquestion of catching the right fields, since it's really a text file you could open it and write some code to go thourgh it and extract the fields yo need.
 

3 more replies
Answer Match 51.66%

Excel XP
Trying to import a spreadsheet with lots of email addresses (Import | Export) into
a contacts folder, error:
An error has occurred in the Microsoft translator while getting the contents of a file system
The Microsoft Excel file “C:\...xls has no named ranges. Use Microsoft Excel to name the range of data you want to import.

Note this has multiple sheets, if I copy the one sheet into a new file and then try the import then I receive error:
An error has occurred in the Microsoft translator while getting the contents of a file system
The File “C:\..xls was not recognised. The Microsoft Excel translator was unable to recognise this file. It could be the wrong file, a version of the file type which is not supported by this translator, or the file might be corrupt

I have saved the “one spreadsheet” as a txt file and tried to import this into contacts, but receive error saying that Microsoft outlook translator is not installed, when inserting my disc doe not seem to find it? (when going into control panel to see options Add | Remove in Microsoft Office I don’t see it here either?)
 

A:Excel XP Trying to import a spreadsheet into Outlook

Well.. managed to run this install (translator) from disc (kinda hung for a while?) anyhow I saved the spreadsheet as a csv file brought into outlook all ok (mapped the fields) all look good in the contacts folder. The reason for all this was to create a DIS list (80 email accounts) Now when going to File - New Dis List and selecting the members (button) and selecting the drop down box for my new contacts, which are all showing and clicking add all I see being moved accross to the other side is the , or ; symbol??? this is for all the contacts?
 

1 more replies
Answer Match 51.66%

I am trying to do a web query on http://www.tntexpress.com.au/interac...imes_tntau.asp with information entered into the text boxes and the result into excel.

I have tried using a macro (in the workbook vba of excel) but it failed and I'm not sure if I am supposed to use post or some other way for text boxes :

Sub Login_WebQuery()
Dim MyPost As String
Const MyUrl As String = "http://www.tntexpress.com.au/interac...esX_tntau.asp?" 'DONT FORGET TO COPY LINK LOCATION BECAUSE TECH SUPPORT GUY SHORTENS THE ADDRESS
Const PostOSuburb As String = "txtOSuburb=CRANBOURNE"
Const PostOState As String = "&txtOState=VIC"
Const PostOCode As String = "&txtOPcode=3977"
Const PostDSuburb As String = "&txtDSuburb=ASPENDALE"
Const PostDState As String = "&txtDState=VIC"
Const PostDCode As String = "&txtDPcode=3195"
Const Postcolmonth As String = "&colmonth=December"
Const Postcolyear As String = "&colyear=2008"
Const Postcolhour As String = "&colhour=15"
Const Postcolmin As String = "&colmin=00"

MyPost = PostOSuburb & PostOState & PostOPcode & PostDSuburb & PostDState & PostDPcode & Postcolmonth & Postcolyear & Postcolhour & Postcolmin

With ActiveSheet.QueryTables.Add(Connection:= _
"URL;" & MyUrl, Destination:=Cells(1, 1))
.PostText = MyPost
.BackgroundQuery = True
.TablesOnlyFro... Read more

A:Import Data from website to excel using vba

Please don't post duplicate threads. Continue the problem resolution here: http://forums.techguy.org/business-applications/782450-excel-web-query.html
 

1 more replies
Answer Match 51.66%

How do I import a CSV file into excel keeping the leading zeros? Excel automatically drops the leading zeros when imported. I do not want to change the column format in the import wizard because I don't know which columns have leading zeros. Has someone figured out a way to import a file into Excel without dropping the leading zeros?
 

A:Excel import with leading zeros

Welcome to TSG jeanniepie,
You have a dilemma. You don't want to configure the column format to text for the offending data. Without intervention Excel will determine that a group of numeric characters in a field is a ....Number. If you want it to be text you have to overide the logic and import as text.

This discussion at social microsoft describes many ways of doing what you want...most require you to know your data. --Depending on the data you may be able to import it all as text?
 

2 more replies
Answer Match 51.66%

I'm trying to create a email distribution list. I've got all the names in excel and I figured the only logical way to do this would be to import the excel spreadsheet into my contacts in outlook and then create my outlook distribution list from my contacts in outlook.

When I go to import my spreadsheet I get the following error message.

"An error has occured in the Microsoft Excel translator while getting the contents of a file system.

The Microsoft Excel file "c:\folder\excel.xls" has no named ranges. Use Microsoft Excel to name the range of data you want to import."

The error makes sense but I don't know how to name a range.
 

A:import contacts from excel into outlook

7 more replies
Answer Match 51.66%

Hi Guys,

I have an Excel template called "Cash Amounts.xls" in drive c:\test\Amount and
an Access database called "Cashdatabase.mdb" and an Access query called "CashMTM".

I want to press a button in Excel which imports the Query from Access to Excel.

I know how to import a Access table into Excel with VB & SQL,but not a query.

Has anyone got an easy example of code I could use for this?

Cheers Justin
 

A:Import an Access Query into Excel via VB

JCutcliffe, welcome to the Forum, you would have had a much quicker response to your question if you has posted it on the Business Applications Forum, as most Access/Excel programmers don't check this forum very often.

Can't you just Copy/Paste Special/Link to the query?
Or it can be populated form Access.
Do you really have to use Excel, why not do what is needed in Access?
 

2 more replies
Answer Match 51.66%

hi guys
I want to import multiple excel files into single worksheet in a seperate excel file?
Is there a macro or procedure I can use to import these files..

all the files that need to be imported are in a single folder and data is in sheets a5 to j56 on each excel file.
 

A:import multiple excel files

I had this code in Access and was able to adapt it for Excel, I can't take credit for the part that collects the file info from the folder, but the rest I have put it.

I can actually use this myself, you just have to remember that Excel only holds 65536 rows.

Also I didn't have time to add a method to set the path of the folder, I want to use the GetFile so I will probably modify it later...for now you need to modify this part of the code in the VB editor to match the folder you want to import

path = "C:\Documents and Settings\User\My Documents\" '*** Edit I added input box

This is a rough draft so it currently only works from the originating book ( I'll upload it), although really I don't think it matters since it serves the purpose of consolidating all the sheets to one. I also added a field to put the file name beside the pasted data.

Code:
Public Function test2()

Range("A1").Select

Application.DisplayAlerts = False
Application.ScreenUpdating = False
Dim strFile As String 'Filename
Dim strFileList() As String 'File Array
Dim intFile As Integer 'File Number
'Dim filename As String
Dim path As String
Dim Srow As Integer ' stores range to paste filename
Dim Erow As Integer ' stores range to paste filename
Dim CopyBook, OrigName As String



path = InputBox("copy the PATH from the Address bar" & vbNewLine _
& "and paste it here")

If path = "" Then

Exit Fu... Read more

1 more replies
Answer Match 51.66%

Hi All,

I have a situation where I need to take data from this format
NAME
Clown, Bozo (8430)
Bunny, Bugs (2940)
Runner, Road (5023)

(basically in column 1 we have a list of last name (comma) first name and in parenthesis the last four of their SSN.)

I want to move the data from that sheet into another where the format is
First Name Last Name
Bozo Clown
Bugs Bunny
Road Runner

I would like the data imported to this new sheet sheet with the first name and last name in two columns instead of one (delimited by comma) and no last four, I want it in this format so I can mail merge that data into a word doc (I already know how to merge) but I don't know how to import the data to have the first and last names separated by columns with no last four of their SSN.
Can anyone help?
- Thanks
 

A:Excel data import problem

Hi there,
Try this macro
Code:

Option Explicit

Sub SplitNames()
Dim s1 As Worksheet, s2 As Worksheet
Dim p1 As Integer, lstRow As Long, xrow As Long, iRow As Long
[COLOR="Red"]Set s1 = Sheets("Sheet1")
Set s2 = Sheets("Sheet2")[/COLOR]
lstRow = s1.Range("A" & Rows.Count).End(xlUp).Row
iRow = s2.Range("A" & Rows.Count).End(xlUp).Row
If s2.Range("A1") = "" Then s2.Range("A1") = "First Name": s2.Range("B1") = "Last Name"
For xrow = 2 To lstRow
p1 = InStr(1, Cells(xrow, "A"), ",")
p1 = p1 - 1
If p1 > 0 Then
iRow = iRow + 1
s2.Cells(iRow, "B") = Left(Cells(xrow, "A"), p1)
s2.Cells(iRow, "A") = Mid(Cells(xrow, "A"), (p1 + 2), InStr(p1, Cells(xrow, "A"), "(") - (p1 + 2))
End If
Next xrow
End Sub

Just check the two lines in Red to see if your sheet's names exist, else change them accordingly

The Instr() function determines in the first case where the , is and in the second place to determine the (

The , and ( must be presnt for this to work.
 

3 more replies
Answer Match 51.66%

Does anyone know how to (if it's even possible) to import data into Excel (into proper fields - name, address, city etc.) from a Word mailing label template? I'm using Office XP and have a large Word file I would like to get to Excel...

Thanks!
 

A:Word/Excel Import/Export

16 more replies
Answer Match 51.66%

On eBay I used to be able to right-click on a table and select 'Export to Excel' and it would bring the contents of the table into a spreadsheet. Now it doesn't work. I look at the HTML and they are using Javascript to generate the table. Is there another way to do this?
 

A:Can't import web page table into Excel

select the text and copy/paste it to excel. Sometimes it will drop it into columns, if it doesn't go to the data menu and select text to columns and convert it into columns depending on the delimeters you see. They probably coded the page to prevent you fom copying, if that is the case it might not let you select the text.
 

1 more replies
Answer Match 51.66%

Hi,

I've got a DB that works like this: I export about 10 tables from Access to Excel. Each table will be exported to one worksheet in the same file. Then I update the data in the worksheets without modifying the field names. Finally, I want to import the data in the Excel to Access.

I could use the Import function in Access but it would mean I need to perform the import action 10 times. I found a line of code that looks that it's what I need but how do I modify it to tell it to import the correct worksheet into the correct table?

I'm really a novice at this so I would appreciate if you could use the following example. For example, tbl1 and tbl2 is exported into the same file A and worksheet is names tbl1 and tbl2. How do I write the code?

Line of code I found:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "Import", Me.txtFileName, True

Thanks a million
 

A:Import from Excel to Access using code

8 more replies
Answer Match 51.66%

I have a .txt file that is imported into Excel using delimiters("^").
I look at the .txt file, and do not see anything different/out of place, but when I import it into Excel 2010, some of the lines end up with a "=" attached.

For example,

.txt Excel 2010
- Three monitors =- Three monitors (resulting in #NAME?)

Why is an "=" inserted into the import?

Thank you.

I have attached some screenshots to demonstrate.

A:Import .txt in Excel 2010 issue

See if setting import step 3 "Column data format" to "Text" helps. Otherwise, need more information about your source material and import parameters.

Regards,
GEWB

3 more replies
Answer Match 51.24%

Recently a symbol or "mini icon" has started to appearing over lower-left quadrant of file thumbs. It is a blue ~square with 2 horizontal white chevrons, ">>". They cover about 1/4 of each xLg photo icon/ thumbnail. I'd like to get rid of these pesky & unwanted mini-icons. A quick screen print of photo files, as thumbnails, is now useless because so much of each photo is obscured.
 

A:Unwanted symbol appearing over file thumbnails (Win 10 syst)

Hi Davenjac, and welcome to TSG.

Are you running Norton360 or some other kind of backup software? It can be disabled in Norton 360's settings by unchecking the "Backup Status Indicators" check box.
 

2 more replies
Answer Match 51.24%

Hello forum,

I have been trying to figure out how to change the status of a file that is present on network discovery on another computer.

I am just going through and assessing each file.

I notice the only person I really would like to share with is anyone that uses the external hard drive - much like the other files on the hard drive that do not have a lock on it.

I know that it may be basic - but I just want a work around for the few folders that I managed to see in computer management.

If someone could please give me a basic idea of what menu's to go into - I promise I will not change the behaviour of any folders.

Thank you.

Just basic steps -

As I am on a network/workgroup and do not want the homegroup - what is the best option.

A:How to remove the lock symbol on a file - no homegroup present

Hello Melissa,

The lock icon in Windows 7 indicates that the file or folder can only be accessed by you.

Remove the Lock Icon from a Folder in Windows 7

1 more replies
Answer Match 51.24%

I was having this issue on my recently updated pc. when i double clicked on an excel file it would not run. tried various things mentioned in the forum. nothing worked.

i always got an error message - filename.xls is not a valid win32 application. thing is that office was looking for "excel office component" - whatever that is.

So I went to Control Panel>Programs>Default Programs.

Tried to change the default program for xls and xlsx files to excel, but it would not show up.

So I went to start and searched for excel.exe. that gave me the path to the actual file.

copied it down - went back to the control panel >programs/default programs > change and scrolled down to the file types, clicked on change > browse . and pasted the file path there.

problem solved. should work for the other office programs as well.
 

A:FIXED IT: EXCEL WONT LAUNCH WHEN I DOUBLE CLICK ON THE FILE - INSTEAD HAVE TO USE FILE-OPEN IN EXCEL

WE are blessed and may you go forth and find enlightenment now you have the answer.
 

3 more replies
Answer Match 50.82%

I need help importing text database (for mailing lists) from ACT 4.0 to Excel 2000. However, I do not have ACT application on my computer, and am not able to work from the other (second) computer - person is using it all the time. Could someone help me with this, step by step somewhat. Should the person I'm doing this for save ACT file: on CD; could they email it to me, also?

Thanks for any help.
Danane
 

A:ACT 4.0 to excel 2000 -can i import text database?

Hi, and welcome to the TSG forum

can they export as a csv file (comma seperated)
then its simple
you just open it in excel.
 

3 more replies
Answer Match 50.82%

Hello Group,

Trying to import one long Excel 2007 column which has only e-mail addresses, into a specific folder in my Windows Contacts. I want to then create a new contact group and then Open that folder with the imported addresses, and do a single Add step, selecting all the imported addresses, from the folder into the new contact group.

Have read some posts about this but it is not working for me (PC Windows Home Premium, Office 2007). Step-by-step:

OK, I save the Excel as a CSV file. Then Tools>Windows Contacts and open the destination folder. Clicking Import > CSV > Import and browse to the Excel file saved in CSV format > Open > Next

Then "Map the fields you wish to import" window appears, showing only the first e-mail address (from the top of the Excel column).

I click on Change Mapping and select "E-mail address" from the list of fields, tick the Import this Field box, and OK, then Finish. Voila.

The e-mails are imported, but they are scattered throughout my Contacts, and the destination folder remains empty.

How do I import to a specific folder in my Windows Contacts? I did not see a destination folder option during the import process, but that folder was opene when I did the import.

Thanks for looking in. Hope someone can solve this, as otherwise I must handle the addresses one-by-one into the Contact Group.

seekinganswers
 

A:Import Excel to Windows Mail Contacts

10 more replies
Answer Match 50.82%

I've got a macro set up on a worksheet in workbook A, which once an hour is exporting data to a worksheet in workbook B. This is housed on a shared drive. I'm trying to set up Workbook C to have a worksheet setup that imports the data from workbook B, so that management can view hourly updates without having to check their email. I've set a query on workbook C to refresh at regular intervals to pull the updates each hour. The problem is that once workbook C refreshes, it locks workbook b preventing any further writes from workbook A. I've tried setting longer intervals between the refreshes, setting the workbook B as shared, and attempted to change the Mode in the OLE QUERY from Share Deny Right to Read.

TL;DR -Basically it boils down to the auto-refresh on workbook c maintaining a connection to workbook b, preventing workbook b from being updated. Is there a way to only have workbook C connect to workbook b during the refresh, instead of maintaining a constant connection as long as auto-refresh is enabled?

Any help is greatly appreciated.
 

A:Excel Import External Data help needed!!

7 more replies
Answer Match 50.82%

when i import data from excel to outlook calendar it imports it only as an appoitment. i wanted to import it as a meeting request. while the mapping fields in the import / export option of outlook show the 'required attendees' field which has been adequately filled in by me the same does not reflect after i check the imported record
 

More replies
Answer Match 50.82%

I'm trying to create a macro to import a webpage on to an excel (2003) worksheet. The website is:
http://wwwagwx.ca.uky.edu/uk_combo.htm

Everything I have tried (and tried, and tried) imports the text only without the gif's. It appears that the gifs might actually be individual links and that may be the problem. I do not need the links, just he pictures.

The following code is just the basic set up. I have not included any of my failed attempts as they are just that...failed stuff.

I did include within the code the urls for each individual gif as I think there might be a way to accomplish this using individual calls, but that seems like a lot of wasted time as there are 20 gifs on the page. I would prefer to open the page once and copy it to my sheet "S" in one shot. Or,open the site once and copy the individual pictures one at a time, as that would work also.

Any direction is appreciated.

Tom

Sub GetJetStreamSite()
Dim b As String
Dim PicAdd(20) As String
Dim Ie As Object
Dim x As Integer

'Create recieving sheet "S"
Application.DisplayAlerts = False
On Error Resume Next
Sheets("S").Delete
On Error GoTo 0
Application.DisplayAlerts = True
Sheets.Add
ActiveSheet.Name = "S"

'Create indivual picture URLs, if needed
For x = 0 To 9
PicAdd(x) = "http://wwwagwx.ca.uky.edu/ldm-images/nhmrf_" & x * 12 + 12 & "_sfc.gif"
PicAdd(x + 10) = "http://wwwagwx.ca.uky.edu/ldm-images/nhmrf_" &... Read more

A:Solved: VBA Import web page into Excel 2003

Unless I am misunderstanding what you are trying to do you should just be able to open Excel and choose FILE >> OPEN and then enter the website URL into the filename text box and click OK or use the following macro command.
Code:
[B]Workbooks.Open Filename:="http://wwwagwx.ca.uky.edu/uk_combo.htm"[/B]
If you follow the steps above the entire webpage will be pulled into the Excel sheet including the pictures but as you indicated above the pictures are embedded hyperlink images. If you would rather have the pictures saved locally to your machine you can run the macro below which will save each image from the website and then edit the hyperlink to point to your local drive instead . Just change the portions in the code that are highlighted in red to reflect the correct URL of the page to download the images from and the save path on your local machine. Hope this helps!!
Code:
Private Declare Function URLDownloadToFile Lib "urlmon" _
Alias "URLDownloadToFileA" (ByVal pCaller As Long, ByVal szURL As String, _
ByVal szFileName As String, ByVal dwReserved As Long, ByVal lpfnCB As Long) As Long
Private Const ERROR_SUCCESS As Long = 0

Sub DownloadPics()

For Each vLink In ActiveSheet.Hyperlinks

vURL = "[COLOR="Red"]http://wwwagwx.ca.uky.edu[/COLOR]" & vLink.Address

vPic = URLDownloadToFile(0&, vURL, "[COLOR="Red"]C:\Test\[/COLOR]" & Mid(vLink.Address, InStrRev(vLink.Address, "/")... Read more

3 more replies
Answer Match 50.82%

guess this could probably be any office app question......regardless......I've got a pretty good sized music library, and I've always maintained a spreadsheet that I pull from the drive the music is on with the following command line prompt:

dir /b /s *.mp3 > c:\music.txt

Once I get it into text, I can manipulate it with excel to my hearts content. All I want to add is the attribute switch to get the size and dates of the files, and I had thought that the /a switch would do that, but no go.

Any ideas?

thanks,

v
 

A:Solved: random excel import question

15 more replies
Answer Match 50.82%

I need some code or formula to automatically add data from one sheet to my main sheet where I would like to put all of my data together. I am able to download sheets off of the net and they are in numerical sequence by date. "19991118damlbmp_zone", "19991119damlbmp_zone" and so on. I need to create a button or something to gather the info from the first sheet and paste it in my main sheet and then gather the info from the second sheet and paste that into the main sheet in the next available row.

Please help if you can
 

More replies
Answer Match 50.82%

Moved from Software Development
Hi, We are a team of 25 who all use the same contact list (which contains addresses, organisation name, tel numbers, emails, contact names etc for approx 600 organisations). We regularly have to bcc all these contacts in to emails. We previously all held the distribution lists (sorted alphabetically by email) and had to let the rest of the team know when details changed so they could be updated by all. The problem with this was that the distribution lists do not hold all the information needed (e.g. addresses, organisation names) and contact information was not always updated as it should have been. I have updated an excel spreadsheet containing all the information and I would like to create a macro for all the team to periodicaly import this data in to Outlook Contacts and possibly create distribution lists from these. I trust this makes sense I am using Outlook 2003.
Thanks
 

More replies
Answer Match 50.82%

A friend has a Lotus Notes worksheet that I need to use, but I use Excel not Lotus Notes. Can I import and, if so, how? Can he transmit via Outlook as an attachment? I use Office 2000 Professional.
 

More replies
Answer Match 50.82%

Help please. Trying to import names and e mail addresses from am Excel spread sheet to my Outlook Contacts. I know the process File<Import <Excel find file etc however when I get to the stage I get a warning ' Cannot import Excel Translator not installed. Would you like to install it now?. Select Yes system searches for the files and then informs me they are not available.

I have XP Home and MS Office Pro 2003 with full package. I have tried checking Installed components from Add remove Programmes and gone round innumerable circles.

Searches on the MS sites have not revealed any answers either.

Is there an easy fix for this can anyone help please. Hope I am posting in the right area - could not see anything specific about Office or Excel Translators.
Thanks
David
 

More replies
Answer Match 50.82%

Hi everyone ... I am not sure if I'm in the right category to discus my problem..
 
I am member in hundreds of groups in Facebook, I want to import (names of the groups) all in one excel file so that I can manage them, I tries copying them all and past into excel but it did not work, so I is there any site out there for that work? or is there other trick else

More replies
Answer Match 50.82%

I need some code or formula to automatically add data from one sheet to my main sheet where I would like to put all of my data together. I am able to download sheets off of the net and they are in numerical sequence by date. "19991118damlbmp_zone", "19991119damlbmp_zone" and so on. I need to create a button or something to gather the info from the first sheet and paste it in my main sheet and then gather the info from the second sheet and paste that into the main sheet in the next available row.

Please help if you can
 

A:Excel: Automatically import data from another workbook

bparker said:

I need some code or formula to automatically add data from one sheet to my main sheet where I would like to put all of my data together. I am able to download sheets off of the net and they are in numerical sequence by date. "19991118damlbmp_zone", "19991119damlbmp_zone" and so on. I need to create a button or something to gather the info from the first sheet and paste it in my main sheet and then gather the info from the second sheet and paste that into the main sheet in the next available row.

Please help if you canClick to expand...

Hi bparker - Not sure I'm reading your intent right, but if you can save the "19991118damlbmp_zone" etc sheets into a book on the desktop you name "Book11" and then open a new book called "Book10" and run the code from Book10 - you can use something like this:

Code:
[SIZE=2]Sub COPYIT()
'this is run from the book named Book10
Dim N%
Application.ScreenUpdating = False
On Error Resume Next '<< error is - "books already open"
Workbooks.Open Filename:="C:\WINDOWS\Desktop\Book11.xls"
For N = 1 To Sheets.Count
Workbooks("Book11.xls").Activate
Sheets("Sheet" & N).Select
Range("A1", Range("A65536").End(xlUp).Rows.EntireRow).Select
Selection.Copy
Windows("Book10.xls").Activate
Sheet... Read more

3 more replies
Answer Match 50.82%

I am using Quickbooks Premier 2004. I am using MicroSoft Excel XP. My operating system is Windows XP. Now for the particulators:
I have a file containing all of the credit card charges for the month. The file is approximately 500 lines of data. I followed the QuickBooks instructions for importing transactions. But it just won't work.
When using the !TRNS and !SPL commands (if that is what they are called), I am told the file does not balance. But the file DOES balance when I hand add everything on my adding machine. So this is an Excel issue. In the 10th decimal place there are numbers. How do I fix?

When I try to import each line as a separate transaction, I am told the import was successful, but NO data goes into QuickBooks. Please someone HELP!
 

A:Problem with Quickbooks transaction import from Excel

If the 10th decimal place is in a calculation, like the total or VAT or similar change the calculation to include rounding to 2 decimal places.
 

1 more replies
Answer Match 50.82%

Hi,

Once I have created some useful macros, I would like them to always be available whenever I create new files. I'd love it if I don't have to import them every time. Is there a place I can put them or some setting I can set so that they will always be present in all new files without having to import?

Thanks!
Lori
 

A:auto import of Excel macros in to all new files?

you can create your Macros in the Personal.xlsx file, this file will get create when you choose to record a macro there the first time, after that you can unhide it and add your code to it. You can also place an excel worbook that has code in the XLSTART folder so it will load whenever Excel is started.

read here about using the Personal file...

http://office.microsoft.com/en-ca/e...to-a-personal-macro-workbook-HA102174076.aspx
 

1 more replies
Answer Match 50.82%

I have SQL Server query that I copied to Microsoft Query:
Code:
SELECT 'Fresh from '+ convert(char(10),(SELECT MAX(Table.Date) FROM Data.dbo.Table),101)
Returning
Code:
Fresh from 08/02/2007
In Excel, which is what I want.
What I don't want is for Excel to create a new column for that one cell. I just want to be able to put the value into an existing cell.

Any way to do this?
 

A:Import a single cell of SQL into Excel 2003

7 more replies
Answer Match 50.82%

I'm running WindowsXP Professional on a Dell Latitude D600, and I recently swapped out my laptop base unit, due to a failure with the prior unit. I successfully swapped over all the peripherals from my old laptop unit (screen, drives, Wi-Fi, battery, etc.) and the laptop started up normally, with no problems.

While not a problem, I just now noticed that on Windows Explorer, under [file] Name column, I see that for everyone of the files listed, there a very small "green checkmark" or a "yellow exclamation mark" in the lower right-hand corner of the symbol that designates the file type (Word, Excel, PDF, etc.). I've never seen that under Windows Explorer before, working this laptop - or any computer for that matter.

Anybody have an explanation for the mysterious symbols that have shown up, all of a sudden? Thanks.
 

A:Solved: Small Symbol w/File Name Icon in Windows Explorer

9 more replies
Answer Match 50.82%

I backed up my outlook pst file last night to do a clean install. Now that it is all up and running, I cannot import the backup.pst. It tells me that access to the file is denied. Any advice on how to get around this would be greatly appreciated! Thanks.
 

A:Cannot import pst file in outlook, it says file access is denied???

Hi musiclover

Copy the .pst file to the hard drive, check the properties of the .pst file and verify it is *not* marked Read-only.

Open instead of Import the .pst file.
In Outlook...version?
File > Open > Outlook Data File
Browse to the location of the .pst file.
 

3 more replies
Answer Match 50.4%

Hi there,

I'm trying to import data from an Excel spreadsheet into a Word document that already has the mail merge set up in it. Whenever I try to do this, I select the source after which it just sits there with a message in Word indicating 'Initiating DDE Link with Microsoft Excel.' I tried it with the same document on another machine and it worked... Is there another way other than reinstalling Word and Excel to fix an issue like this. I already tried /unregserver and /regserver and also tried creating another document with a mail merge.

Thanks a lot in advance!!
 

More replies
Answer Match 50.4%

Hello I have an Excel spreadsheet I'd like to import to my Google gmail contact list/email. Does anyone know how to do this? Thanks!
 

A:Can I Import Excel Contact Database to Google Gmail? How?

Hi mhanigan, welcome to TSG.

Yes, you can save the Excel file as a .csv file and then go to your Contacts in Gmail. Select Import and then browse to the csv file and it will import the contacts. Hope that helps.
 

3 more replies
Answer Match 50.4%

Hi Folks,
I found the following thread:
http://forums.techguy.org/business-applications/541487-merge-excel-dates-into-outlook.html

At best I am capable of copy pasting code - and I guess I'm slightly failing at that even.
I simply wish to be able to update an excel with dates of future tasks, in a particular column, and have these automatically appear as tasks on a particular date in calendar. Ideally column a (name of task) and column F (date in format 1.1.1.) would both be incorporated into the task, which would be allocated to date X in calendar.
I am using Outlook version 14.0.4734.1000

I have associated with Outlook 14.0 object library already. This is what i have so far (the first line is incorrect, presumably amongst others):
Code:

Sub ExportAppointmentsToOutlook(14.0)
Dim olApp As Outlook.Application
Dim olApt As AppointmentItem
Dim blnCreated As Boolean

'Read the table with appointments:
Dim arrAppt() As Variant, i As Long
arrAppt = Range("A2", Cells(Rows.Count, "F").End(xlUp)).Value
On Error Resume Next
Set olApp = GetObject(, "Outlook.Application")
If olApp Is Nothing Then
Set olApp = CreateObject("Outlook.Application")
blnCreated = True
Err.Clear
Else
blnCreated = False
End If
On Error GoTo 0
'Create the outlook item for the table entries:
'Rows:
' Row 1 = date
' Row 2 = starttime
' Row 3 = endtime
' Row 4 = Description
' Row 5 = ... Read more

More replies
Answer Match 50.4%

Hi,
I'm completely new to vba and trying to modify a code I found here but failed.
While the original code exports cell data (1 row only) from excel into the form fields of a Word document, I tried to modify the code to work for multiple rows, one after the other.
My code works for the first row and generate a word file as supposed, but immediately stoped with an error message "Runtime Error -2147417848 (80010108), "The Object Invoked Has Disconnected from Its Clients"
Could anyone help me modify the code so that it works please? Thanks a lot!
I'm using 2003 excel and word.
P.S. I know this can be easily done by mail merge but I would like to use Word form for further process.

Code:
Option Explicit
'Requires reference to Microsoft Word (11.0) Object Library
Sub Copy_Cells_To_Word_Document()
Dim rng As Range
Dim row As Range
Dim wdApp As Word.Application
Dim wdDoc As Word.Document

Set rng = Range("A2:E4")
Set wdApp = New Word.Application
Set wdDoc = wdApp.Documents.Open(Filename:="C:\Desktop\file.doc", ReadOnly:=False)
wdApp.Visible = True

For Each row In rng.Rows
Copy_Cell_To_Form_Field wdDoc, Range("D" & ActiveCell.row).Value, "Surname"
Copy_Cell_To_Form_Field wdDoc, Range("E" & ActiveCell.row).Value, "Forenames"
Copy_Cell_To_Form_Field wdDoc, Range("B" & ActiveCell.row).Value, "Ref"

wdDoc.SaveAs ("C:\... Read more

A:import excel data into word form fields

6 more replies
Answer Match 50.4%

I have run into an interesting problem here... We run an AS400 server from which data is imported into excel 2003 format for billing and other items... We have a user that has run in to a problem. Any X-fers of data in excess of 16000 lines will cause a statement from excel stating that the data will not fit onto the worksheet. As some may or may not know, the current limitation of 2003 is ~ 65K lines. The CPU itself is not an issue, or atleast should not be an issue P4 2.26 256 RAM... ideas?
 

A:Excel 2003 Data Import Limit 16K lines?

Can I ask?
How is the data imported?
From File-Open with Excel?
Or opening a CSV?
Or what?

Are you absolutely certain that an older version of Excel is not being launched when he opens the file?

If the type to be saved under Tools-Options-Transition just "Excel workbook" or some lesser version (tho I don't know if it would cause this issue).
 

3 more replies
Answer Match 50.4%

I have tried using a web query for what I am trying to do, and it just wont work. So I am wondering how I can copy an open webpage to excel automatically.
 

A:Solved: How do I import data from a webpage that is open to excel?

7 more replies
Answer Match 50.4%

Hello,

I'm going to be importing ~150 separate .dat files into a single excel spreadsheet. The files have no headers, and I want them stacked on top of each other in the same columns. Each file is 18 columns wide and 640 rows long. Is there a way to do this that does not involve macros? I'm going to be doing this multiple times over the next few months and I would like to be able to do it myself, or at least modify the code. The files are numbered in an ordered, sequential fashion eg. KM070201000, KM070201001, KM070201002, etc.

I've tried a few solutions on the web for .txt files but they don't seem to work for my .dat files.

Thanks
 

A:Solved: Import multiple .dat files into one Excel sheet

http://www.excelforum.com/excel-general/345607-batch-import-dat-files.html
Any use?
 

3 more replies
Answer Match 50.4%

Tried doing this but I get scattered pieces imported.

Got as far as dragging address from an excel file to email field in Outlook, but get an error and bits and pieces.

Don't want to import one by one.

i shortened the excel file to just one column with e-mail addresses.

Got to be a way.
 

A:Solved: Import e-mail addresses to Outlook from Excel

Hi holymoly

In the Address Book in Outlook Express, enter at least one contact.

Then Export the Address Book as a Text File (Comma Separated Values) (.cvs) file to the Desktop.
This will give you a template to work with.

Open the .cvs file and paste the e-mail addresses into the correct field.
Save and close the .cvs file, then Import it into the Address Book.
File > Import > Other Address Book > Text File (Comma Separated Values) > Import
Browse to the .cvs file on the Desktop.
Let us know if that works for you or not.
 

2 more replies
Answer Match 50.4%

I'm trying to import a contact list from Excell 2003 (11.80...) SP3 to Outlook 2007 (12.0) MSQ (12.0)
When I try to map the fields, I can only drag one "vlue" at a time, and when I I try to map another one, it seems to disapear. I went and maped all the fields, one at a time using the Map Custom Fields and it imported all the Excell fields into one Outlook field.
I'm useing Windows XP
I tried and tried all day, can somenoe help???
 

A:Solved: Can/t import contacts to Outlook 07 from Excel 2003

7 more replies
Answer Match 50.4%

Hi. I'm trying to make an excel sheet with a button that will prompt an import box ("open" window) where I can highlight 1-100 different files, and excel will read it and dump all of the data into its own sheet (one sheet per text file). Is this possible?

Thanks.

(edited for clarity)
 

A:Solved: Excel import multiple files via dialogue box

xmmx,

What version of Excel are you using. It makes a difference.
 

1 more replies
Answer Match 50.4%

I have an excel file with a column with values like 100, 200, 500, 500-02, and 500-04.
Access wants the column to be a number because 500-02 is not one of the first records.

If I use the acImport or acLink I get the same results. Which is an error importing (I get all the data just not the text values in the column) or a null value in the link when view from Access (even though you can open the spreadsheet with excel and see the true data). If I use the import Wizard and change the Field to text it that data is fine.

I also tried acImporting to an existing table with the field set a text but it changes it back to numeric and screws up.

I have a vision impared user and I need a button click to get this data into access.

Thanks for reading my post.
 

A:Solved: ACESS: import excel field as text

7 more replies
Answer Match 50.4%

I have an excel spreadsheet which has names ( first and surname in single column under NAMES ) and email addresses (under EMAIL) which I want to import into my Outlook Personal Address book. I have followed advice of previous post but still only get the email addresses, no names. Tried suggestion of inserting a userdefined name for the spreadsheet but I still only get the option of email address in the import-from column. I have tried renaming the columns, I have tried changing them around. Is it because I don't have addresses and phone numbers?
 

A:Solved: Import contacts from Excel into Outlook 2003

8 more replies
Answer Match 50.4%

Hi Guys,
Any clue on how to import data from excel to outlook contact list and creat distribution list ...
Thanks in advance ..
 

A:import Excel to outlook contacts in specefic format

Create a distribution list in Outlook and then export the contacts list to a CSV file. THis will give you an idea of how the DL's are formatted and how individual contacts are referenced as a part of that DL.
 

1 more replies
Answer Match 50.4%

Am using Windows 7 with 64 bits and I am trying to import information from an Excel7 spreadsheet into Printshop 23.1 mail merge. Have addressed several issues: Win 32 extension installed, turned Excel7 info into .txt format, have successfully merged the two.

What I am experiencing is ALL of the information (only 4 text columns) with 175 lines will not merge into workable file. I am told by the UltraMail Merge program that I can match column headings but when I do, the information is either in the wrong order OR missing certain fields altogether. I know this is an older version of Printshop (purchased in December of 2011) but I do not want to lose all my projects if I purchase a newer version. Any ideas on how to make this one work?

If not, do I need to uninstall my older version before installing new? OR, can I install the new and the old will merge?
 

More replies
Answer Match 50.4%

Hello Helpful Folks,

I have searched with no luck for a solution to my problem. Here's the rundown:
Running Windows XP
Using Outlook 2007, Excel 2007

I want to take a database in Excel and import it into Outlook. Not sure if my screenshot is attached, but I do not have an option to "Import/Export" under File. Any other way around this?? Thanks for the help.
 

A:Solved: Cannot Import Addresses from Excel to Outlook 2007

6 more replies
Answer Match 50.4%

Hello guys

I need some help please in Excel macro and VBA.

I am a coop student, and my my boss wants me to do the following :

A software on my pc collects various csv files from several other pc's on the plant. There are 3 different files.

What I would like to do is to run a macro every day which opens that software, import all the csv files to an excel spreadsheet, add the specific header to each file ( I have 3 different headers in one excel file, one for each type of file) and then save the files in xls format.
Could someone provide me with the VBA code for this please?

Thanks
 

A:Running excel macro to import csv files from a software on my pc

8 more replies
Answer Match 50.4%

Hi, I am looking for a macro to import contacts from excel. We are a team of 25 who all use the same contact list (which contains addresses, organisation name, tel numbers, emails, contact names etc for approx 600 organisations). We regularly have to bcc all these contacts in emails. We previously all held the distribution lists (sorted alphabetically by email) and had to let the rest of the team know when details changed. The problem with this was that the distribution lists do not hold all the information needed (e.g. addresses, organisation names) and contact information was not always updated as it should have been. I would like to create the macro for all the team so that they can periodicaly update their contacts. I trust this makes sense
Thanks
Moved to Business Applications.
 

More replies
Answer Match 50.4%

Here's a weird one, I have a WinXP PC, with a hidden system file in the root of C:\ that is approximately 8 bytes in size. The filename shows up as the following image:http://imgur.com/ywamEnr
Namely Unicode characters
ℤ™☠
U+2124, U+2122, U+2620
Double-Stroke Z, Trade Mark symbol, Skull and Crossbones.
I have no idea how it got there or what software created it, but it looks decidedly suspicious (although Symantec Endpoint Protection and Malwarebytes are detecting nothing).
Has anyone seen anything like this before?
 
Is this likely to be part of some malware?

A:Odd looking file (Double-Stroke Z, Trade Mark symbol, Skull and Crossbones!)

 
 
G'day spelk and Welcome to BC !
 
Lets try this first : Download and run the following programs in the order they are listed....copy and post the resulting logs in your reply/s.
 
RKill created by Grinler (aka Lawrence Abrams), the site owner of BleepingComputer.
Malwarebytes Anti-MalwareAdwCleanercreated by Xplode.Junkware Removal Toolcreated by thisisu.
 
RKill.
* Double-click on the Rkill desktop icon to run the tool.
* A black DOS box will briefly flash and then disappear. This is normal and indicates the tool ran successfully.
* If not, delete the file, then download and use the one provided in Link 2.
* Do not reboot until instructed.
* If the tool does not run from  the link provided, please let me know.
___________________________________________________
 
MBAM (Malwarebytes)
 * Double-click mbam-setup.exe and follow the prompts to install the program.
* At the finish of the installation, be sure a checkmark is placed next to Update Malwarebytes' Anti-Malware and Launch Malwarebytes' Anti-Malware, then click Finish.
* If an update is found, it will download and install the latest version. <<< most important )
* Once the program has loaded, select Perform quick scan, then click Scan.
* When the scan is complete, click OK, then Show Results to view the results.Be sure that everything is checked and click Remove Selected.
* When completed, a log will open in Notepad.
* Post the log back here in your next ReplyBe sure t... Read more

11 more replies
Answer Match 50.4%

Its been a long time since i tried this, So i cant identify what I did to cause it .

Trying to drag multiple .sut ( brush files ) into Art-App it belongs. From the File Explorer window. Was able to do this many times in the past.

I noticed something ; when I use the search engine called
" Everything " from its window interface, if I call up the files in that window, then I'm able to drag and drop the files from that window, directly into the Art app. But cant do it from the File explorer window like I was able to do before.

Windows 10 home basic.

One suggestion, I read in the windows 7 forum, there might be some registry change that happened. But I dont know about such things, just wanted to suggest a idea. Anyone can help ?
I

More replies
Answer Match 49.98%

Hi there,

I am trying to use SQL.REQUEST to pull data from one excel file (a master data file) to another one, and I can't get it to work. I think I don't have the correct connection string specified.

I'm using Excel 2002 on Windows 2000.

The task is, I need to build dynamic queries based on other cells in the "output" spreadsheet, such as, get a count of all records in the master file where the date field is equal to [cell reference] and the ID field is equal to [another cell reference] and a third field is equal to [third cell reference]...
So that, if the values in those referenced cells change, the records that match (and get counted up) will be different.
Also, there will be at least 10 different queries (I do a sum on a field that is a time duration, an average on that same field in another, etc) in different places on the spreadsheet.

I was able to get a simple query to work in Microsoft Query if I used static values, ie, I typed them directly into the criteria... however, these need to by dynamic so that when the same spreadsheet (a report template) is "saved-as" and new values for the criteria are input, the queries don't have to be re-created.

So, using MS Query, I can connect to the master data file and get the correct result... but I believe what I really need to use is SQL.REQUEST, so I downloaded the ODBC add-in and installed that.
I just can't seem to figure out what my connection string argument needs to be.
Th... Read more

A:Solved: sql request in excel file, to another excel file - connection string?

Nevermind folks - I googled +excel +"connection string" for probably the 20th time in 4 days... I usually investigate all result about 7 pages deep before giving up, and this morning, all of a sudden a new result popped up right at the top:
http://www.connectionstrings.com/excel

at about the same time, my boyfriend finally took a look at it, and he came up with this result: http://www.devlist.com/ConnectionStringsPage.aspx

I used the syntax in this example
Code:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1";
AND IT WORKS!
(I almost got up and danced, I was so happy)

Just thought I'd come back and post the solution, in case anyone else ends up finding this thread in the same position I was in.

Now how do I mark this thing solved?
 

1 more replies
Answer Match 49.98%

Hi,

Does anyone know how to change the text import wizard default from tab to semicolon? TI is not hard to choose but some of our end-users are having difficulty. I thought if I changed the default it would help.

Thanks!
 

A:Change Delimter Default in Excel Text Import Wizard

7 more replies
Answer Match 49.98%

We changed one of our computers to Windows XP SP 2 and in doing so I had to update office and access 2003. In doing so I see we can't export our database from excel and bring it into access as a table. I heard there was a lawsuit that prevented the linking now.

I've seen a few work-arounds but I can't get them to work. The error message is "could not find installable ISAM" but when I read the microsoft articles it doesn't really tell you how to do it. I'm not an IT guy. I read somewhere that you can change the connection string...but I don't know how or where to do that.

I seem so close...

Any help would be greatly appreciated.

SteveO
 

A:Access 2003 trouble import excel files as tables...

You'll have to edit the query and connections.
ISAM as far as I know is a ODBC driver which has to be bought and installed, it's system bound as far as I know, so maybe that's the problem that you 'lost'the ISAM ODBC driver after the update ???
 

1 more replies
Answer Match 49.98%

Hello,
I'm without any success hardly trying to modify (as begginer I'm still unable to create) some macro's I found in this forum in order to send data from Excel sheet into a specific public (or not if it's too heavy) calendar in Office 2010.
Import would take place with a push of a button and duplicates should not be allowed...

Even a simple line like: Dim olApp As Outlook.Application gives an error ...Maybe I'm getting tired...

And how should I modify those lines in order to select a specific Calendar (using Folder(Calendar name) in place of GetDefaultFolder in the lines mentioned here under?
Set olNS = OL.GetNamespace("MAPI")
Set olFolder = olNS.GetDefaultFolder(olFolderCalendar)

If someone would be kind enought to give me a help, here are some details about my Excel sheet:
Column A "Company", Column D "Date soon", Column G "Date Late"
Column A is fully completed, but columns D and G have some lines without any date...
 

More replies
Answer Match 49.56%

Hi,

Referring to the post with subject line "Solved: Excel: How to import multiple text files in single worksheet", which is already in solved state.
I had a doubt and so i have opened a new thread for this.
I have downloaded the first sheet attached in the post mentioned above and I have changed the file names in the sheet2. But of no result.
Here I just wanted to know the procedure of how to use this to import the data from text files.
Please help me here. Early reply is highly appreciated.
Thanks in advance for the help.

BR
Nagasayana reddy J
 

A:Solved: Excel: How to import multiple text files in single worksheet

11 more replies
Answer Match 49.56%

Help Request: formula or macro to Import all text files (tab seperated text file) in one worksheet
(NOT as seperate sheets in one work book). [Excel 2013]

Thanks in advance
 

A:Solved: Excel: How to import multiple text files in single worksheet

11 more replies
Answer Match 49.56%

When I open an html file with Notepad I can see all the tags. How do I import html files into XL and have the html files appear in the XL cells with all the tags showing? I want to limit the number of lines I import into XL.
 

More replies