Having Excel write to FileMaker Pro - GoFuckYourself.com

pornguy · 05-06-2024, 10:46 AM

Has anyone ever done this?
I can get FMP to write to Excel But not the other way. Anyone have a clue on how to make that work?

fuzebox · 05-06-2024, 11:17 AM

FMP should be able to import CSV?

(wow blast from the past, I built Filemaker databases in the 90s)

pornguy · 05-06-2024, 12:03 PM

Quote:

Originally Posted by fuzebox

FMP should be able to import CSV?

(wow blast from the past, I built Filemaker databases in the 90s)

Yeah we are messing with an old system but its just a good way to do it.

What I need is that a remote person access the Excel sheet and make changes and those changes reflect in the Filemaker system.

MaDalton · 05-06-2024, 12:07 PM

last time I heard this name was approx 2000

fris · 05-08-2024, 12:55 PM

cant u both use excel?

pornguy · 05-09-2024, 06:25 AM

Quote:

Originally Posted by fris

cant u both use excel?

The system is a bit older and FileMaker does things excel can not. So we kind of need it to work.

In the long run I will replace Filemaker but wanted a work around until I can.

fris · 05-09-2024, 07:08 AM

Quote:

Originally Posted by pornguy

The system is a bit older and FileMaker does things excel can not. So we kind of need it to work.

In the long run I will replace Filemaker but wanted a work around until I can.

excel can read csv? i would jus use csv on both ends and have a shared document somewhere like google docs or dropbox.

Huggles · 05-09-2024, 08:21 AM

I bet I could figure it out, I spent a lot of time working on encoding and decoding JSON to various formats and had issues like this at the beginning. Probably something to do with your delimiters.

pornguy · 05-09-2024, 04:36 PM

Quote:

Originally Posted by Huggles

I bet I could figure it out, I spent a lot of time working on encoding and decoding JSON to various formats and had issues like this at the beginning. Probably something to do with your delimiters.

Thanks. I will look into that. And if I cant work it out I will see if we can get you involved.

05-06-2024, 10:46 AM	#1
pornguy Too lazy to set a custom title Industry Role: Join Date: Mar 2003 Location: Homeless Posts: 62,911	Having Excel write to FileMaker Pro Has anyone ever done this? I can get FMP to write to Excel But not the other way. Anyone have a clue on how to make that work? __________________ PornGuy skype me pornguy_epic AmateurDough The Hottes Shemales online! TChicks.com \| Angeles Cid \| Mariana Cordoba \| MAILERS WELCOME!

05-06-2024, 12:07 PM	#4
MaDalton I am Amazing Content! Industry Role: Join Date: Feb 2004 Location: Cheque Republic Posts: 39,804	last time I heard this name was approx 2000 __________________ AmazingContent.com - providing only the best content and service since 2003 Monetize your content on Veegaz.com - one of Germanies largest VOD sites Skype: madalton02826 - Email: oltecconsult [at] gmail [dot] com

05-08-2024, 12:55 PM	#5
fris Too lazy to set a custom title Industry Role: Join Date: Aug 2002 Posts: 54,875	cant u both use excel? __________________ Since 1999: 69 Adult Industry awards for Best Hosting Company and professional excellence. WP Tube Themes

05-09-2024, 08:21 AM	#8
Huggles Confirmed User Join Date: Feb 2003 Location: Kelowna Posts: 8,886	I bet I could figure it out, I spent a lot of time working on encoding and decoding JSON to various formats and had issues like this at the beginning. Probably something to do with your delimiters. __________________ I make my money from people jerking off

05-06-2024, 11:17 AM	#2
fuzebox making it rain Industry Role: Join Date: Oct 2003 Location: seattle Posts: 21,841	FMP should be able to import CSV? (wow blast from the past, I built Filemaker databases in the 90s)