Converting Excel to a dba file to Import into Goldmine

[RonRothstein]

Iam having the most difficult time taking info off a spreadsheet and converting it to a dba file. This is the first time I am doing it so I do not even know if I am doing it correctly. Then I think I have to do some sort of mapping but I am not sure what that is. If anyone could help me I would be thankful!

 

[barrydb]

I'm not sure about .dba files but when I save data to a .dbf file I have to name the range I'm saving as "database" before I can save the file correctly.

 

[Jack in the UK]

Hi prob the only one who uses Goldmine on this site, your need to explain EXACTly what you are doing, im no expert in GM 2002 thou: but ill have a go!!

Jack

 

[RonRothstein]

I have basic address and client information. I don't know if I convert the files correctly. I leave the headers on the first line in the spreadsheet - Name, Address, etc. Is that correct? I thought when I import the info it would help me map the data. Also, do I use create database after I import the data or do I need to do that at all? I keep getting an error message before it goes to the mapping function in GM. I must be converting the file wrong, but I don't know where I am going wrong! UGH!!! Any help is appreciated.
Ron

 

[Jack in the UK]

Hi this is going to sound very stupid BUT

Please can you tel my click by click drop down by drop down EXACTLY what you have done.

lets say excel.xls in in My Docs and go from there ....

IE
Click file select import blar blar

Ill try EXACTLY what you are doing and work from there

Also change the data but can you post the top 2 lines of the top be imported excel file

ie
name Number date amount whtever
Jack 123 25/9/02 100 what